Transforming into Table Pivot or Unpivot?

[Anonymous]

Dear all,

How do I, using power query, transform as illustrated below?

From:

Column 1	Column 2
Project Name	A
Time	3
Score	9
Value	10
Project Name	B
Time	2
Score	7
Value	5

To:

Project Name	Time	Score	Value
A	3	9	10
B	2	7	5

Thank you,

[Anonymous · Accepted solution]

I found the solution from Youtube:

https://www.youtube.com/watch?v=okJxIOwYEOM#t=2.792633