Help, please - How to rearrange 1 column of data into 4 columns ?
Here is another, first time I saw it, it was provided by Ron Coder
In the first of 4 contiguous columns (for this example, assume column G) put
this formula:
=INDEX($A:$A,(ROWS($1:1)-1)*4+COLUMNS($G:G))
Then fill it right over to column J
Then fill the 4 formulas on down the sheet as far as you need to go.
Same comments about Edit | Copy | Paste Special, etc.
"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
|