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!
Social Networking Bookmarks