Re: one column to three

David,

I might be doing it wrong - but I dont think thats quite what I need (I
probably didnt describe it clearly).

Currently I've got:

Column A row 1, 4, 7, n = name
Column A row 2, 5, 8, n = address
Column A row 3, 6, 9, n = tel

I want to create
Column B = Name
Column C = Address
Column D = tel

I'm now thinking along the lines of a macro to select every third row,
copy and paste it. Cant quite figure out how to select several rows at
the same time.

I'm doing this:
For rw = 1 To 300 Step 3
Cells(rw, 2).Select
Next rw
Selection.Copy
Range("C1").Select
Active***.Paste

but it just copies the last row selected, not them all

Maybe theres a simpler way than a macro?

Andy

.