Excel Transpose Help

[Mac1206]

Hello, I a have a spreadsheet of about 1600 rows in which I need to get into another format....

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>

 

[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