turning rows into columns?
 

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

turning rows into columns?
 

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