Excel Problem

[MonkeyBalls]

I've got a list in excel of a shipping number and shipping address in two columns like this:

ID01 123 high street
ID01 London
ID01 SW1 4OT
ID02 55 Short Streeet
ID02 Roundhay
ID02 Leeds
ID02 LS8 7TH
ID03 etc etc

I need it in the following format

ID01 123 High Street London SW1 4OT
ID02 55 Short Street Roundhay Leeds LS8 7TH

I've tried using a pivot table but i can't get it to work! Anyone got any ideas!? There are like 32000 lines making up about 10000 addresses!
The addresses are made up of anythign between 4 and 8 lines, some are international with international postcodes.

Karma to the solution provider! hehe!

[flipper321]

Easy to do - hard to explain...

wouldn't take me long if you want to post it and I'm allowed to see it...?

[MonkeyBalls]

Can you try to kind of explain it becuase its kind of confidential company addresses unfortunately?

[MonkeyBalls]

Its ok problem solved! Cheers Anyway!