Deleting formula sources without destroying formula output, using Numbers for Mac
Select the columns with the data that you want to preserve.
Choose Copy from the Edit menu (or hit Command ⌘+C).
Choose Paste Formula Results from the Edit menu (or hit Shift ⇧+Command ⌘+V).


You should end up with just the results of the formula.