arrange data

try this formula

=INDEX($A$1:$G$3000,(ROW()-1)*2+(COLUMN()>11)+1,COLUMN()-8-(2*(COLUMN()>11)))

place in cell I1, copy across to cell Q1

then copy I1:Q1 down as far as you need!

you can then cut and paste special / Values to where you want the data!

If you're looking to override the original data with the revised output then based on sample file you could run a VBA routine along the lines of:

Please Login or Register  to view this content.