Hi

I have a worksheet that I need to change into a different order and merge
data for same people (based on unique ID) into one line.

An example might help explain what I'm trying to achieve. I have the
following columns/titles:

Column A Column B Column C Column D Column E Column F
ID 1st name Surname Code Amount 1
Amount 2
1 Bob Smith SGC
20.00
1 Bob Smith TAV 25.00
2 John Jones ABC
40.00


Now, I need to reorder and merge data so that I only have 1 line for each
person in a new worksheet based on the 'Code' so that:

Column A Column B Column C Column D Column E Column F
ID 1st name Surname SGC TAV
ABC
1 Bob Smith 20.00 25.00
2 John Jones
40.00

Any ideas how this can be done???? I'm stumped.

Thanks

Chris