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.
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.