Help with Excel

Hi, I have a problem which hopefully you can help with, I have a column with customer names and their sales for 2016 and a column with customer names and their sales for 2017. Some names appear in on...

excel

Detlef_Lewin
Sep 28, 2018
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.

Matthew Plant

Copper Contributor

Sep 28, 2018

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.

Detlef_Lewin

Silver Contributor

Sep 28, 2018

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.

Forum Discussion

Help with Excel

Resources