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 > Alter Column Structure > Merge Columns
The Merge Column filter has two simple options to specify the beginning and end columns that need to be merged, with a third option for omitting or including an additional space between the merged data. Once this is applied any data in those cells with be collapsed into a single column.