Hi,
I'm not able to program VBA, but I don't think what I need can be anchieved only by standard formulas.

I have some rows like

A 1 2 3 4 5
B 1 2 3 4 5..100
C 1 2 3 4 5..299

(where numbers are random, and also letters could appear, like "A 3 45 45 2 xx a m")

what I would like to get is something like
A 1
A 2
..
A 5
B 1
B 2
..
B 100
C 1
C 2
..
C 299

so, repeating the row label for each column with characters on the original row.

Can you please help me?
Thanks a lot!!