khaldouz wrote:
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


i don't understand your problem, please attach a example file in excel
so i can help.