Partially transpose data which pasted as a single column
Solution 1:
In below example, formula in C1
:
=INDEX($A$1:$A$12,ROW(A1)*4-4+COLUMN(A1))
Drag down and right...
Basically the same as this answer on SO.
Note: You can change *4-4
to any number of columns you want to transpose into > *n-n
Solution 2:
You can use this formula:
=OFFSET($A$1,(ROW(A1)-1)*4+COLUMN(A1)-1,)