Forum Discussion

ELAIR7's avatar
ELAIR7
Copper Contributor
May 22, 2024

Merging Columns in Excel

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!

  • 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.

    • ELAIR7's avatar
      ELAIR7
      Copper Contributor
      Thank you, this is a great suggestion!

Resources