I'm in need of a method to concatenate each row from B1 to the last cell with data on the same row. ( it varies)
The maximum range I might need would be B1:CD1
I'm unable to add each cell within the function, as its too large.

I have about 100 rows like this.

Any ideas?

Thanks!