VB Code to reorganize data in a row

Hello:

Please refer to attached file.
I have data as shown in row 1.
I need to re-arrange this data from row 5 down as follows.

A5 = 20160831 (1st Text Item)
A6 = Brazier B6 = 1363.34 C6 = -20.89
A7 = DQ B7 = 889.33 C7 = -8.82

and so on.

Let me know if you have any questions.
Thanks.

Riz

Hi,rizmomin
i'm not sure if this the code you need

Please Login or Register  to view this content.

Hi Simcode:

Thanks a lot, i would be able to use above code with some modification.
Riz