is their any other way of transposing the data rather than using copy, paste special and transposing.
is their any other way of transposing the data rather than using copy, paste special and transposing.
1) Use TRANSPOSE function
2) Use INDEX function with indexes based on ROW() and COLUMN()
3) Write a VBA proc
HTH
--
AP
"Vkhara" <[email protected]> a écrit dans
le message de news: [email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks