Filter by column in Numbers
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.