rearrange a column of businesses into meaningful rows & columns

[Gingertrees]

I'm trying to parse out the data in an Excel spreadsheet with over 10,000 lines of data. Unfortunately, it's not organized in a very helpful manner, with each line being a separate row, but every business taking up 4-6 rows, as below:

A's Business 1
400 Some Road
Cedar Falls, IA
Phone: (800) 111-2222
www.address1.com
info@address1.com
Aaron's Name place
110 L Street
Omaha, NE
Phone: (888) 222-3333
A1 Something
4 Flagstaff Rd
Rochester, NH
Phone: (800) 000-1234
www.a1something.com
brandon@a1somes.com
ABC Other Stuff
5000 Old Seward Hwy
Anchorage, AK
Phone: (800) 111-3455
www.abcothers.com
ABC Place, LLC
(etc)

If they all had 6 rows, that would be a pretty simple routine to write and perform... but the variable length, with some having 4 rows and some having 6... I just don't know what to do. Ideas?

 

[sheetspread]

I mean:

1x
2x
3x
4x
7x
1x
2x
3x
4x
5x
7x


becomes

1 x
2 x
3 x
4 x
5 0
6 0
7 x
1 x
2 x
3 x
4 x
5 x
6 0
7 x