Merge Columns Filter
What is it?
The Merge Column filter can be used to combine data from one or more columns.
How is it used?
Add Table Filter > Split, Merge & Transpose > Merge Columns
The Merge Column filter has two simple options to specify the beginning and end columns that need to be merged. Once this is applied any data in those cells with be collapsed into a single column.