Help, please - How to rearrange 1 column of data into 4 columns ?
Bothers me that I didn't combine the 2 minuses!
=INDEX($A:$A,4*ROWS($1:1)+COLUMNS($A:A)-4)
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
Enter this anywhere, then copy across 4 columns, and then down as needed:
=INDEX($A:$A,4*ROWS($1:1)-3+COLUMNS($A:A)-1)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mark246" wrote in message
...
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
|