Merging Columns in Excel

[ELAIR7]

Hello -

I have a data set of around 19,000 rows of data, including addresses which span across 50 columns. 

What I am trying to achieve, is for excel to review each row within the 50 columns specifically and return into a single cell any of the address information found within the 50 columns. I'm aware of the concate method, but was seeing if there was a more simpler way of extracting the data? 

I've added an example (on a smaller scale) which may be useful to visually see, with a desired outcome in column S. 

Thanks for any help!

[#2]

@ELAIR7 

An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

[#3 · Accepted solution]

@ELAIR7 If you have a modern Excel version (i.e. 365 or 2021) you can use TEXTJOIN.

[#4]

Thank you, this is a great suggestion!

[#5]

it worked, thank you!