1) Use TRANSPOSE function

2) Use INDEX function with indexes based on ROW() and COLUMN()

3) Write a VBA proc

HTH
--
AP

"Vkhara" a écrit dans
le message de news: ...

is their any other way of transposing the data rather than using copy,
paste special and transposing.


--
Vkhara
------------------------------------------------------------------------
Vkhara's Profile:
http://www.excelforum.com/member.php...o&userid=35033
View this thread: http://www.excelforum.com/showthread...hreadid=547784