I need to perform some work with large worksheets. Most of them have over 1700 rows and multiple columns spanning from A to IZ. The problem is that the last set of column with text need to be combined for example
All data needs to be combined into a single cell for example:
P55=Joe, Marry, ..., Bob
Cell numbers are approximate they vary on all worksheets.
Can someone recommend a way of doing it fairly easy? concatenate function would require tedious work.
I am using Excel 2010.