turning rows into columns?

[Aoife101]

If you have information in Row 1 e.g

a b c d e f g
1 CF513 GT636 ER254 GH564 ER543 BG215 FG232

Is there any quick way of converting that row of information into a column e,g.

A
1 CF513
2 GT636
3 ER254
4 GH564
5 ER543
6 BG215
7 FG232

[Xcelion]

Hi,

Copy the data and
then EDIT->PASTE SPECIAL and check Transpose


Thanks
Xcelion

"Aoife101" wrote:

>
> If you have information in Row 1 e.g
>
> A B C D E F G 1 CF513 GT636 ER254 GH564 ER543 BG215 FG232
>
> Is there any quick way of converting that row of information into a
> column e,g.
>
> A
> 1 CF513
> 2 GT636
> 3 ER254
> 4 GH564
> 5 ER543
> 6 BG215
> 7 FG232
>
>
> --
> Aoife101
> ------------------------------------------------------------------------
> Aoife101's Profile: http://www.excelforum.com/member.php...o&userid=35928
> View this thread: http://www.excelforum.com/showthread...hreadid=568278
>
>