macro join columns with blank for block of data

[churong]

I am new to macro. Hope someone can help me in the macro

Data:
ColA ColB ColC ColD ColE ColF ColG ColH ColI ColJ ColK ColL ColM ColN ColN.....ColIR
A1 B1 C1 D1 E1 F1 _____________________H1 I1 J1 K1 L1 M1
A2 B2 C2 D2 E2 F2 _____________________Blank_____________ O2 P2 Q2 R2 S2 T2
Blank
Blank ________________________________ H4 I4 J4 K4 L4 M4
A5 B5 C5 D5 E5 F5 _____________________Blank_____________ O5 P5 Q5 R5 S5 T5
....Row 65000

Desired Result
A1 B1 C1 D1 E1 F1 ______V3 W3 X3 Y3 Z3 AA3
A2 B2 C2 D2 E2 F2 ______V4 W4 X4 Y4 Z4 AA4
A5 B5 C5 D5 E5 F5
H1 I1 J1 K1 L1 M1
....
O2 P2 Q2 R2 S2 T2
...
Row65000 (continue new column )

The Range is block of data of 6values occupying 6 columns each rows randomly with some blank between and space between block column. I need to rearrange the data following in order from A-F, H-M, etc and once the row 65000 is reached, new block of columns will continue

Can somebody help

Rong