Thank You Andy, problem solved.
Both suggestions work.
However I'll use the concatenate formula only as it's the only change to the original sheet.

thanks again, I'm sure I'll be back