A spin on the old TRANSPOSE question

[Drewski]

A "search" turns up dozens of repetitions of the same question: "How d
I convert a column of data into a row of data?" Easy: Copy, Past
Special, Transpose. But how about for a column of repeating data?

E.g.:

A
B
C
D
A
B
C
D
A
B
C
D and so on, to be converted to:

A B C D
A B C D
A B C D, continuing.

I recorded a quick macro to copy and paste special (transpose), but i
kept recopying the original copied data. Manually copying and pastin
is going to take way too long. Is there a formulaic method of doin
this?

Thanks!:

 

[Dave Peterson]

If your data is in A1:Axxx, then you can put this formula in B1 and drag across
to E1:

=INDEX($A:$A,(ROW()-1)*4+COLUMN()-1)

Then drag down until you run out of data.

Then copy|paste special|values and delete column A.

 

[Drewski]

Nice!

Thanks Dave