is their any other way of transposing data?

[Vkhara]

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

[Ardus Petus]

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
>