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))

enter image description here

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,)

enter image description here