DeanToronto
New Member
- Joined
- Jul 2, 2014
- Messages
- 1
I have just started playing around with PowerQuery and find the features awesome. Doing a normal unpivot has been soooo simplified, but I have been stumped on how to do this particular task. I have tied search this forum and Google, but I have trouble coming up with coherent search criteria to explain what I am trying to do.
I have data that looks something like this (although there are more like 90 columns and 600 rows):
<tbody>
</tbody>
I would like to end up with normalized data that looks more like this:
<tbody>
</tbody>
Is this possible?
Any suggestions would be very much appreciated!
I have data that looks something like this (although there are more like 90 columns and 600 rows):
| EmplNum | Name | Type1Hrs | Type1Rate | Type1Amt | Type2Hrs | Type2Rate | Type2Amt |
| 1 | John Smith | 40.0 | 10.00 | 400.00 | 5.0 | 15.00 | 75.00 |
| 2 | Jane Doe | 35.0 | 12.00 | 420.00 | 0.0 | 18.00 | 0.00 |
<tbody>
</tbody>
I would like to end up with normalized data that looks more like this:
| EmplNum | Name | Type | Hrs | Rate | Amt |
| 1 | John Smith | Type1 | 40.0 | 10.00 | 400.00 |
| 1 | John Smith | Type2 | 5.0 | 15.00 | 75.00 |
| 2 | Jane Doe | Type1 | 35.0 | 12.00 | 420.00 |
| 2 | Jane Doe | Type2 | 0.0 | 18.00 | 0.00 |
<tbody>
</tbody>
Is this possible?
Any suggestions would be very much appreciated!
