Averil - From the Table View, first select the (adjacent, ungrouped and unaggregated) columns you wish to collapse into a single column. Note that you cannot do this by clicking the column header (which sets a sort). You can select a subset of rows, or the entire field/column by selecting the cells to be collopased. Hold the shift key down and drag the Table View scroll bar to bottom of the column or row range you want to select.

Once you have all the cells in all columns to be collapsed selected, choose View Tools > Tools > Collapse values. It will convert any numeric fields to text and prompt you to specify the delimiter to be inserted between values, which can be a blank space. It will also prompt you to set the data type option to tokenised, allowing you to filter on individual values within the collapsed column if you wish.