1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query Problem

Discussion in 'Power Pivot, Power Map etc' started by ExcelSur, Mar 10, 2019.

  1. ExcelSur

    ExcelSur New Member

    Messages:
    21
    I am trying to accomplish the Solution tab using Power Query. Please see attached spreadsheet

    My spreadsheet has sales and data tabs with the Solution expected tab

    If the Product in the Product column in sales tab starts with 3 then Power Query should get the information from the data tab which shows 3000 for Product Code and Three Thousand for Product Name and concatenate as 306410-3000-Three Thousand

    Can Power Query do this. I dont know how to write VBA Code

    Thanks for your help

    Attached Files:

  2. AlanSidman

    AlanSidman Active Member

    Messages:
    459
    See attached. I imported both tables into Power Query. Added a custom column to each table and extracted the left most number from the product column. Merged the two tables on the new column. Then concatenated the appropriate columns with a "-" in between. Deleted the unecessary columns

    Attached Files:

    ExcelSur and Thomas Kuriakose like this.
  3. ExcelSur

    ExcelSur New Member

    Messages:
    21


    Alan,
    Thanks for your help

Share This Page