Hello, I a have a spreadsheet of about 1600 rows in which I need to get into another format....
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Part[/TD]
[TD="width: 64"]ID[/TD]
[TD="width: 64"]Amount[/TD]
[/TR]
[TR]
[TD="class: xl63"]79123[/TD]
[TD="class: xl63"]5233122[/TD]
[TD="class: xl63"]44.18[/TD]
[/TR]
[TR]
[TD="class: xl63"]79123[/TD]
[TD="class: xl63"]11606476 [/TD]
[TD="class: xl63"]95.1[/TD]
[/TR]
[TR]
[TD="class: xl63"]79123[/TD]
[TD="class: xl63"]22346192[/TD]
[TD="class: xl63"]149.81[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]12129561[/TD]
[TD="class: xl63"]72.77[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]15504217[/TD]
[TD="class: xl63"]79.24[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]17257196[/TD]
[TD="class: xl63"]36.89[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]20765123[/TD]
[TD="class: xl63"]37.11[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]19830543[/TD]
[TD="class: xl63"]66.63[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]22166231[/TD]
[TD="class: xl63"]34.58[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]24132158[/TD]
[TD="class: xl63"]73.11[/TD]
[/TR]
</tbody>[/TABLE]
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....
[TABLE="width: 960"]
<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"] Part [/TD]
[TD="width: 64"]ID 1[/TD]
[TD="width: 64"] ID 2 [/TD]
[TD="width: 64"]ID 3[/TD]
[TD="width: 64"] ID 4[/TD]
[TD="width: 64"] ID 5 [/TD]
[TD="width: 64"]ID 6 [/TD]
[TD="width: 64"] ID 7[/TD]
[TD="width: 64"] Amt 1[/TD]
[TD="width: 64"]Amt 2[/TD]
[TD="width: 64"]Amt 3[/TD]
[TD="width: 64"]Amt 4[/TD]
[TD="width: 64"]Amt 5[/TD]
[TD="width: 64"]Amt 6[/TD]
[TD="width: 64"]Amt 7[/TD]
[/TR]
[TR]
[TD="align: right"]79123 [/TD]
[TD="class: xl66"]5233122[/TD]
[TD="class: xl66"] 11606476 [/TD]
[TD="class: xl66"]22346192 [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl67"] 44.18[/TD]
[TD="class: xl67"]95.1[/TD]
[TD="class: xl65"]149.81[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]79314 [/TD]
[TD="class: xl66"]12129561[/TD]
[TD="class: xl66"] 15504217[/TD]
[TD="class: xl66"]17257196[/TD]
[TD="class: xl66"] 20765123[/TD]
[TD="class: xl66"] 19830543 [/TD]
[TD="class: xl66"]22166231[/TD]
[TD="class: xl66"] 24132158[/TD]
[TD="class: xl66"] 72.77[/TD]
[TD="class: xl66"]79.24[/TD]
[TD="class: xl66"]36.89[/TD]
[TD="class: xl66"]37.11[/TD]
[TD="class: xl66"]66.63[/TD]
[TD="class: xl66"]34.58[/TD]
[TD="class: xl66"]73.11[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Part[/TD]
[TD="width: 64"]ID[/TD]
[TD="width: 64"]Amount[/TD]
[/TR]
[TR]
[TD="class: xl63"]79123[/TD]
[TD="class: xl63"]5233122[/TD]
[TD="class: xl63"]44.18[/TD]
[/TR]
[TR]
[TD="class: xl63"]79123[/TD]
[TD="class: xl63"]11606476 [/TD]
[TD="class: xl63"]95.1[/TD]
[/TR]
[TR]
[TD="class: xl63"]79123[/TD]
[TD="class: xl63"]22346192[/TD]
[TD="class: xl63"]149.81[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]12129561[/TD]
[TD="class: xl63"]72.77[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]15504217[/TD]
[TD="class: xl63"]79.24[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]17257196[/TD]
[TD="class: xl63"]36.89[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]20765123[/TD]
[TD="class: xl63"]37.11[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]19830543[/TD]
[TD="class: xl63"]66.63[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]22166231[/TD]
[TD="class: xl63"]34.58[/TD]
[/TR]
[TR]
[TD="class: xl63"]79314[/TD]
[TD="class: xl63"]24132158[/TD]
[TD="class: xl63"]73.11[/TD]
[/TR]
</tbody>[/TABLE]
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....
[TABLE="width: 960"]
<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"] Part [/TD]
[TD="width: 64"]ID 1[/TD]
[TD="width: 64"] ID 2 [/TD]
[TD="width: 64"]ID 3[/TD]
[TD="width: 64"] ID 4[/TD]
[TD="width: 64"] ID 5 [/TD]
[TD="width: 64"]ID 6 [/TD]
[TD="width: 64"] ID 7[/TD]
[TD="width: 64"] Amt 1[/TD]
[TD="width: 64"]Amt 2[/TD]
[TD="width: 64"]Amt 3[/TD]
[TD="width: 64"]Amt 4[/TD]
[TD="width: 64"]Amt 5[/TD]
[TD="width: 64"]Amt 6[/TD]
[TD="width: 64"]Amt 7[/TD]
[/TR]
[TR]
[TD="align: right"]79123 [/TD]
[TD="class: xl66"]5233122[/TD]
[TD="class: xl66"] 11606476 [/TD]
[TD="class: xl66"]22346192 [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl67"] 44.18[/TD]
[TD="class: xl67"]95.1[/TD]
[TD="class: xl65"]149.81[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]79314 [/TD]
[TD="class: xl66"]12129561[/TD]
[TD="class: xl66"] 15504217[/TD]
[TD="class: xl66"]17257196[/TD]
[TD="class: xl66"] 20765123[/TD]
[TD="class: xl66"] 19830543 [/TD]
[TD="class: xl66"]22166231[/TD]
[TD="class: xl66"] 24132158[/TD]
[TD="class: xl66"] 72.77[/TD]
[TD="class: xl66"]79.24[/TD]
[TD="class: xl66"]36.89[/TD]
[TD="class: xl66"]37.11[/TD]
[TD="class: xl66"]66.63[/TD]
[TD="class: xl66"]34.58[/TD]
[TD="class: xl66"]73.11[/TD]
[/TR]
</tbody>[/TABLE]