PDA

View Full Version : Transpose



jaishree
04-24-2007, 03:49 AM
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
04-24-2007, 04:20 AM
Transpose won't work here, you will need to loopthrough the data and extract from it.

jaishree
04-24-2007, 04:29 AM
HI XLD!!!,
Can i pls get a macro code for the same ...


pls help

jaishree
04-27-2007, 12:00 AM
hi ,
can anyone pls help me on this :doh: