copy vertical data to horizontaly

[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

 

[Frank Kabel]

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

 

[Domenic]

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!