Forum Discussion
Transforming into Table Pivot or Unpivot?
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,