Forum Discussion
Solved
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 ...
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.
Thank you, this is a great suggestion!