convert rows of street addresses into individual columns (no transpose)

addresses.xlsxI am an excel novice (so please be gentle )

I have a larger large list of addresses copied off the web.
The data is of multiple rows per record and is variable. It ranges from 3 lines (rows) upto 5 rows.
Each record is separated by an empty cell or row.

example

Name
address 1
address 2
Suburb City Postcode
Phone
BLANK
Name
address 1
Suburb City Postcode
BLANK
Name
address1
address2
Suburb City Postcode
BLANK

I would like it be as:
Column1 Col2 Col3 Col4 Col5 Col6 Col7
Name Address1 Address 2 Suburb City Postcode Phone

I have done a similar process years ago, but then my data was a consistant 3 rows. So I was suggested to use one of these

=INDIRECT("A"&1*(ROW(A1)-1)+COLUMN(A1))

=INDEX($A:$A, COLUMN() - 1 + 3 * (ROW() - 1) )
and it had worked.

How can I achieve my required result and what do I use. Transpose does not work for me.

There are lots of records.. please help. Can email a sample file

Thanks
Anant

Welcome to the forum.
you can upload the file here so others could take a look.
Go to edit ->Advanced-> manage attachment..