Combine columns into a new one

[Meiko]

Hi all,

I am tryin got combine multiple columns into 1. To be clear here is what I am trying to do:

this is my current table:

Resource	Project A	Project B	Project C	Project D
R1	2		1
R2		3
R3			9
R4	4
R5		5		6
R6
R7	3

I am trying to create the following table:

Resource	Project	Hours
R1	Project A	2
R1	Project C	1
R2	Project B	3
R3	Project C	9
R4	Project A	4
R5	Project B	5
R5	Project D	6
R6
R7	Project A	3

Thanks for your help,

[tamerj1 · Accepted solution]

Hi @Meiko 
You need to unpivot the data using power query. 

[Meiko]

Thanks!