Hi Sammyandco,

Welcome to the forum.

After applying the concatenate function in one row, you just need to copy / paste OR drag it down.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>