Forum Discussion
Re: Help with Excel
Thanks Detlef,
I'm new to excel, please can you advise how to use the power query solution to produce the combined result from the original two sets of data?
Thanks.
1 Reply
Click on "Show Queries" on the Data tab in the ribbon. That will open the "Queries & Connections" pane.
This workbook has three queries.
Double-click on one of the queries to get to the query editor.
Open the navigation pane on left side to see all the queries.
"tbl_2016" and "tbl_2017" just load both tables into PQ. They are loaded as connection only.
The last query is build via the UI. Both tables are appended. The columns "Year" and "Sales" are unpivoted. Then the table is pivoted with column "Year".
The query "Append1" is loaded as a table to the worksheet.
