Forum Discussion
Solved
Turn strings within rows into columns with data from another column (pivot?)
Hello,
I cannot figure out how to perform the below operation, I believe it is either pivot, or group, but cannot seem to find it.
Inital table:
| Lot | Part | Measurement | Value |
| 1 | 1 | A | 54 |
| 1 | 1 | B | 65 |
| 1 | 2 | A | 74 |
| 1 | 2 | C | 54 |
| 2 | 1 | A | 31 |
| 2 | 1 | B | 15 |
| 2 | 3 | A | 45 |
| 2 | 3 | D | 34 |
Final Desired table:
| Lot | Part | A | B | C | D |
| 1 | 1 | 54 | 65 | ||
| 1 | 2 | 74 | 54 | ||
| 2 | 1 | 31 | 15 | ||
| 2 | 3 | 45 | 34 |
To do this in Power Query select columns "Measurement" and "Value", go to transform toolbar and select pivot columns.
End state
1 Reply
- jsaunders_zero9
Responsive Resident
To do this in Power Query select columns "Measurement" and "Value", go to transform toolbar and select pivot columns.
End state