Hi,
I now have a row with 3 inputs, divided by the alt+enter function.
eg.
A1 contains
ABC
XYZ
JKL
and B1 contains a single value, say 10.

How do i convert it to A1 - ABC, B1 - 10.. A2 - XYZ, B2 - 10.. A3 - JKL, B3 - 10?

Thanks,
Rukia