G
Guest
Excel move multiple columns into single set of column
How can I automate this
I have a huge sheet
A B C D E F G H I --- ZZ
R1
R2
R3
RN
and I want to move every block of 4 columns(or n cols) to sit under A -D
so
R1 A B C D
R2
R3
R4
R5 E F G H
R6
R7
R8
R9
R10 I J K L
etc
How can I automate this
I have a huge sheet
A B C D E F G H I --- ZZ
R1
R2
R3
RN
and I want to move every block of 4 columns(or n cols) to sit under A -D
so
R1 A B C D
R2
R3
R4
R5 E F G H
R6
R7
R8
R9
R10 I J K L
etc