Hi guys,
I need to populate a row with data from an corresponding rows data, WITH additional numbers tagged onto the end - is this possible?
E.g. From COLUMNB (fig.1), i need to generate EARTH123 (or any number) and filled in into COLUMNA, all the way down (see fig2)
fig.1
COLUMNA COLUMNB
EARTH
MARS
PLUTO
ENGLAND
SCOTLAND
WALES
fig.2
COLUMNA COLUMNB
EARTH123 EARTH
MARS456 MARS
PLUTO654 PLUTO
ENGLAND23 ENGLAND
SCOTLAND23 SCOTLAND
WALES4544 WALES
THANKS!!!!
I need to populate a row with data from an corresponding rows data, WITH additional numbers tagged onto the end - is this possible?
E.g. From COLUMNB (fig.1), i need to generate EARTH123 (or any number) and filled in into COLUMNA, all the way down (see fig2)
fig.1
COLUMNA COLUMNB
EARTH
MARS
PLUTO
ENGLAND
SCOTLAND
WALES
fig.2
COLUMNA COLUMNB
EARTH123 EARTH
MARS456 MARS
PLUTO654 PLUTO
ENGLAND23 ENGLAND
SCOTLAND23 SCOTLAND
WALES4544 WALES
THANKS!!!!