iWork Numbers: how to copy only filtered values?
I do this using the following method:
- Filter the original table so that the rows you want are left visible and those that you don't are hidden.
- Select the whole table copy it (command + c).
- Create a blank table.
- Select the first cell (A1).
- Paste (command + v)
This puts only the visible cells into the blank table, expanding columns and rows if necessary.