MULTIPLE ROWS IN TRANSPOSE

[Guest]

Hi alll......

a small doubt...
I have a excel with date in different rows sequentially like..

A B C
1 12 13 14
2 15 16 17
3 18 19 20

If I arrage all the numbers in one column in "A". I use
pastspecial->transpose.
This is done only one row at a time. I need to transpose all at once in a
single column, like..

A
1 12
2 13
3 14
4 15
5 16
6 17
7 18
8 19
9 20

Pls help me... I have bulk data to arrage in one coumn.

thanks
Narendra

 

[Graham Mayor]

You might do better if you ask in an Excel forum. This one's for Word!

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>