Forum Discussion
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!
- OliverScheurichGold Contributor
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.
- ELAIR7Copper ContributorThank you, this is a great suggestion!
- Riny_van_EekelenPlatinum Contributor
- ELAIR7Copper Contributorit worked, thank you!