Sep 22 2021 03:20 PM
Hi, I have a problem with the following issue:
I have several tabs with the same header (data varies):
Title | Territory | April | May | June |
X | A | 1 USD | 4 USD | 7 USD |
XX | B | 2 USD | 5 USD | 8 USD |
XXX | c | 3 USD | 6 USD | 9 USD |
I would need to create the following:
Title | Territory | Date | Values |
X | A | April | 1 USD |
XX | B | April | 2 USD |
XXX | c | April | 3 USD |
X | A | May | 4 USD |
XX | B | May | 5 USD |
XXX | c | May | 6 USD |
X | A | June | 7 USD |
XX | B | June | 8 USD |
XXX | c | June | 9 USD |
I am very new to Power Query. I would appreciate if someone could explain the steps I need to take in order to get the second table.
Thank you!
Gabriella
Sep 22 2021 04:58 PM
Step 1: This is your data
Step 2: Select any cell in your data range then click Data>From Table/Range then click ok
you get this screen:
Step 3
Select the Title and Territory columns
Right click the selected columns then select Unpivot other columns:
and viola, now all you have to do is rename the Attribute column to dates by double clicking on the column header Attribute
Then click close and load
cheers