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!

​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!  Read More

​