Moving data

[gbeard]

I have customer information in column A. It looks like this:

customer
address
phone

customer
address
phone

and so on for over 500 customers. How can I move the data so it fills
a1:c500? So it would look like:

customer address phone
customer address phone

and so on.

Thanks for any help,

 

[JE McGimpsey]

one way:

In a second sheet enter:

A1: =INDEX(Sheet1!A:A,4*(ROW()-1)+1)
B1: =INDEX(Sheet1!A:A,4*(ROW()-1)+2)
C1: =INDEX(Sheet1!A:A,4*(ROW()-1)+3)

Copy down as far as necessary. Then select columns A:C on the second
sheet. Copy, then Paste Special, selecting the Values radio button.