JMB's is an excellent solution, just requires one formula with a mod to it
based on the first column you place it into.

If you want an alternative set of formulas, then these could be used. As
JMB did, I'll assume your starting in column B and with 1st name in A1:
First column to pick up 1st name (B1), formula:
=OFFSET(Sheet1!$A$1,(ROW()-1)*4,0)
in next column, to pick up last name:
=OFFSET(Sheet1!$A$1,(ROW()-1)*4+1,0)
in next column, to pick up city:
=OFFSET(Sheet1!$A$1,(ROW()-1)*4+2,0)
and in 4th/last column to pick up zip code:
=OFFSET(Sheet1!$A$1,(ROW()-1)*4+3,0)

Then fill those formulas down the sheet as far as needed, and follow JMB's
instructions on Edit | Copy followed by Edit | Paste Special w/Values option
selected if desired.

I've included the sheet name of the source information in my formulas; if
these are going on the same sheet as the source data, then the sheet name
part ( Sheet1! ) is not required.



"Mark246" wrote:

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