Hi all, first time on here and have a challenge splitting up some address data before using it for geo location. Does anyone had a formula / script that can move the rows of data into columns, each on one row? Sample below, if you imagine each block of data is over 3 rows, and seperated by one row.
Tried a few things but can't quite crack it!
Cheddar Cycle Store
Valley Line Ind Park, Cheddar, Somerset, BS27 3EE
01934 741300
Swift Cycles
8 Strype Street, London, , E1 7LF
02073 770 502
City Cycles - Chichester
44 Bognor Road, Chichester, West Sussex, PO19 7TG
01243 539992
Fred Williams Cycles
37 Snow Hill, Wolverhampton, West Midlands, WV2 4AG
01902 428407
Thanks
Dave
Bookmarks