Excel Transpose Help

[Mac1206]

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]

 

[sandy666]

Ok, I'll look at this a little later

 

[Mac1206]

Thanks for all your help Sandy....If you could, please include screen shots in your steps, I really desire to learn this and taking a course in Udemy....Thanks again...

 

[sandy666]

if you see error just refresh in QueryTable but it should work with your path: C:\Users\amccoy\Desktop\Part_Data.csv

example file