Filter by column in Numbers I have blanks in each row.  Can I hide them?

I want to be able to select a row and gather it together by getting rid of the empty cells.
Perhaps the simplest way to accomplish this is to use the CONCATENATE
Function in a new column and then hide the others.


At an appropriate place in your table, add a new column.  (Perhaps at the end)
Add a formula such as = TRIM ( CONCATENATE( A2, " ", A3 )) adding in the calculation as many cells as needed.
Drag the formula down the column.
Now, hide the columns.


The Trim function removes the blank space you add in the formula in the event the first row is blank.

See examples below.