turning rows into columns?

A

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
 
X

Xcelion

Hi,

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


Thanks
Xcelion
 
Top