Transpose or Convert column data set to multiple columns-variable!

Dear Sirs,

I'm trying to convert a single column data set to multiple columns.

There are no spaces or delimiters. As you can see from data set below, fields are starting from First Name and until the next First Name there's sometimes 3 columns, 4 or even 5.

I have tried to use OFFSET function but it only make sense if you have fixed number of columns between 2 sets that you are comparing.

This is the column data set example:

First Name 1
1 Street
Town1 State1 1000
(01) 1234 1234
First Name 2
Town2 State2 2000
(02) 1342 1324
First Name 3
Unit3
3 Street
Town3 State3 3000
(03) 1231 1313

This is how it should look with proper coding:

First Name 1 1 Street Town1 State1 1000 (01) 1234 123
First Name 2 Town2 State2 2000 (02) 1342 1324
First Name 3 Unit3 3 Street Town3 State3 3000 (03) 1231 1313

Or if not possible, perhaps like this:

First Name 1 1 Street Town1 State1 1000 (01) 1234 123
First Name 2 Town2 State2 2000 (02) 1342 1324
First Name 3 Unit3 3 Street Town3 State3 3000 (03) 1231 1313

Thank you very much.