copy vertical data to horizontaly

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi, I have a list of data verticaly, which continues to
be as follows

Name
address
phone #
city
Postal code

I want them to put in horizontal order every five records
to be on one row, so the following names, etc.. be on the
2nd row and so on...

I appreciate your help
Thanks
 
Hi
if this data is on sheet1 starting in cell A1 put the following formula
on your second sheet in cell A1:
=OFFSET('sheet1'!$A$1,(ROW()-1)*5+COLUMN()-1,0)

now copy this formula to the right and down. Afterwards select your
data range, copy the data and insert it again with 'Edit - Paste
Special - Values' to remove the formulas
 
Hi Mike,

Assuming that your list is in Column A, put this formula in B1, copy
across and down:

=OFFSET($A$1,ROW()*5-5+COLUMN()-COLUMN($B$1),0)

Then, select the new data, Copy > Paste Special > Values, and delete
Column A.

Hope this helps!
 
Back
Top