I have a list of records in this format

Name 1
Address 1
City 1
State 1

Name 2
Address 2
City 2
State 2

Name 3
Address 3
City 3
State 3

I would like to put these on a row for each record, i.e.

Name 1 Address 1 City 1 State 1
Name 2 Address 2 City 2 State 2

Any help is much appreciated.