Use "concatenate"

Merge the data into a new column. Then you have to make the column format "text" (i think) and then you can fill down.
That's the gist of it really although I'd have to do it to remind myself of the exact procedure.
If no one else gets back to you, remind me and I'll do it

Posted By: CB41, Oct 22, 14:06:45