Forum Discussion
ELAIR7
May 22, 2024Copper Contributor
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!
- Riny_van_EekelenPlatinum Contributor
- ELAIR7Copper Contributorit worked, thank you!
- 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!