hi,
can any one provide a macro or formula to converT row to column as in
the example below:.
FROM
A B1 K1 C1
B KI GI M1 H1

TO

A B1
A K1
A C1
B K1
B G1
B M1

Thank you


--
khaldouz
------------------------------------------------------------------------
khaldouz's Profile: http://www.excelforum.com/member.php...o&userid=36406
View this thread: http://www.excelforum.com/showthread...hreadid=561824