formatting-transpose

[zoharb]

Respected,
HAPPY THANKSGIVING
I have a table of 5*33 which I want to transpose
By using normal PASTE SPECIAL -TRANSPOSE
eg it is moving Mar 2009-Nov 2011(which is now vertically) to
Mar 2009-Nov 2009 (horizontally
But I want it as nov 2011-mar 2009 because other data that has to be included for charting is in that form
Please help
Thanks in advance
Zohar Batterywala

 

[paddydive]

got... it...

As it is a Ubound i.e. Upper Boundry.. is will consider the 4 and not 0
and if we will use Lbound then it will consider the lower boundry i.e. 0

hv i got it correct Alvin

 

[alvinwlh]

ya..

 

[paddydive]

Thanks you very much Alvin

God Bless.... and HAPPY THANKSGIVING