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