arrange data

[angs]

Hi all, nice to meet u. I'm a new comer hopefully can ask for the advice. Thx
I have some question, plz see attach file.

[squiggler47]

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!

[DonkeyOte]

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.

[angs]

Thx mr.donkey...but i'm really don't understand about using vba, still beginner =)

[angs]

thx squi, wow...that one save a lot of time =) but if u don't mind could you please explain about the function that you gave me. Many thx.