Help, please - How to rearrange 1 column of data into 4 columns ?
if your data is in A1:A8, try this in cell B1
=INDEX($A$1:$A$8,(ROWS(B$1:B1)-1)*4+COLUMNS($B1:B1))
then copy the formula across and down as far as necessary. Adjust range
references as needed to reflect where your data actually is. Then copy the
cells in columns B:E and Edit/Paste Special Values to hardcode the data (if
you wish to delete the original data in column A afterwards).
Be sure to back up your file in case of mishaps.
"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
|