Transpose

[jaishree]

hi,
i want to create a macro to transpose the data in the columns.. i know the logic behind the same i.e:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _ :=False, Transpose:=True
but the problem here is that i need to transpose the columns in a particular fashion.

I am attaching the file with the desired outpu.

[Bob Phillips]

Transpose won't work here, you will need to loopthrough the data and extract from it.

[jaishree]

HI XLD!!!,
Can i pls get a macro code for the same ...


pls help

[jaishree]

hi ,
can anyone pls help me on this