Hello, I a have a spreadsheet of about 1600 rows in which I need to get into another format....
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
My result need to look like this and I don't have a clue to how I'm going to get through this? Thanks for your support....
<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>
</tbody>
Part | ID | Amount |
79123 | 5233122 | 44.18 |
79123 | 11606476 | 95.1 |
79123 | 22346192 | 149.81 |
79314 | 12129561 | 72.77 |
79314 | 15504217 | 79.24 |
79314 | 17257196 | 36.89 |
79314 | 20765123 | 37.11 |
79314 | 19830543 | 66.63 |
79314 | 22166231 | 34.58 |
79314 | 24132158 | 73.11 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
My result need to look like this and I don't have a clue to how I'm going to get through this? Thanks for your support....
Part | ID 1 | ID 2 | ID 3 | ID 4 | ID 5 | ID 6 | ID 7 | Amt 1 | Amt 2 | Amt 3 | Amt 4 | Amt 5 | Amt 6 | Amt 7 |
79123 | 5233122 | 11606476 | 22346192 | 44.18 | 95.1 | 149.81 | ||||||||
79314 | 12129561 | 15504217 | 17257196 | 20765123 | 19830543 | 22166231 | 24132158 | 72.77 | 79.24 | 36.89 | 37.11 | 66.63 | 34.58 | 73.11 |
<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>
</tbody>