Splitting up blocks of data seperated by blank row

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

hi,
how does your data look like now and how do you want it to look like then ?
can you show before/after in the file ?
thanks.
AL

Thanks Al - I've attached a new version of the spreadsheet which shows the two versions, or below is the same. Just want it moved into columns so I can process for geo location;

Before

Cloud 9 Cycles
38 Store Street, , , WC1E 7DB

Askew Cycles
The Old Brewery, Kendal, Cumbria, LA9 6EN
01539 728057

Pedal & Spoke
The Little Shop, Peaslake, Surrey, GU5 9RR
1306731639

After

Cloud 9 Cycles 38 Store Street, , , WC1E 7DB
Askew Cycles The Old Brewery, Kendal, Cumbria, LA9 6EN 01539 728057
Pedal & Spoke The Little Shop, Peaslake, Surrey, GU5 9RR 1306731639

hi again,
does the attached file do what you want ?
AL

address sample.xlsx

Awesome thanks, hadn't thought around it that way at all!

Done it through the 2,000 addresses and it's worked well.

you're welcome :-)