Power Query - question

Copper Contributor

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

1 Reply

@GabriellaFerenc 

 

Step 1: This is your data

Yea_So_0-1632354194280.png

Step 2: Select any cell in your data range then click Data>From Table/Range then click ok

Yea_So_3-1632354388812.png

you get this screen:

Yea_So_4-1632354464538.png

Step 3

Select the Title and Territory columns

Yea_So_5-1632354788635.png

Right click the selected columns then select Unpivot other columns:

Yea_So_6-1632354860180.png

and viola, now all you have to do is rename the Attribute column to dates by double clicking on the column header Attribute

Yea_So_7-1632354915824.png

Yea_So_8-1632355022748.png

Then click close and load

Yea_So_9-1632355076015.png

 

 

cheers