Can anyone offer a solution ?

Hello everyone,

Can anybody offer a solution to my problem:

I have a list of 4 digit numbers in column A (I need to retain leading zeros for numbers < 1000)
I have 19 cells in column B containg alpha-numeric data.
I want Column C to contain a copy of the alpha-numeric data preceded by the 4 digit number in column A.
I'm after a Macro, I think ! or some functions to make life easier as Column A has 440 entries !

It doesn't go down on paper as easy as it looks so I've attached an example:

Many thanks in advance for any help one this one.

The .jpg is unreadable - I'll try something else - - -