I've got One column of data that has...
FirstName
LastName
City
ZipCode
John
Smith
Tulsa
89456
Joe
Adams
Denver
65454
etc...

Exactly 4 rows for each person.
How can I move the data for a person onto one row, 4 columns? Like...
John Smith Tulsa 89456
Joe Adams Denver 65454

Thanks, in advance, people.

Mark246