Forum Discussion
nmhung49
Helper II
Helper IICombine Data with Different Columns on Multiple Sheets into a Single Sheet
I have 2 sheets with data Sheet 1 Product Group 1 Customer Produc Group 2 Amount A Hiti Arg 10 B ...
TomMartens
Super User
Super UserHey,
Import the sheets using Power Query, this will lead to two queries and then:
- Reorder the columns in one of the queries
- Use the Append operation in the Combine ribbon of the Home Menu:
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
Regards,
Tom
nmhung49I can not Reorder the columns in one of the queries
Can you help me? with example
P/s: I am not use create Table to do It
- TomMartens
Hey,
I assume you already imported both sheets into Power BI Desktop Power Query.
From Power BI desktop open Power Query (select Edit Queries from the Home menu)
Select one query, mark the query you want to move to another place, drag the column using the mouse (you have to do the on the column name):
As the manual reordering is "recorded" as a transformation step, it will work even if you refresh the data.
Regards,
Tom
- nmhung49
I know, but the data is incorect in power query in the columns
I want picture ex1 to picture ex2