Hi,

I have two coloumn. A and B.

In column A, I have the header in dynamic order. Like in A2, A4,A5, A8, A12 and so.

In B column, I have the data in each cell, lie B2 to B3, B4, B5 to B8, B9 to B12

Catch is, B2 to B3 data is for A2 header.
B4 is for A4 header.
B5 to B8 data is for A5 header.

I need VBA which will transpose the B column data against A column header in C2. So i dont know have to scroll down all the way down to 1000 rows each time..

Please advice,
Thanks