How to keep vloopup values even after deleting the vlookup table array?

I am working on a excel file which has two sheets:

• Sheet A (uses vlookup functions to obtain values)


• Sheet B (contains the vloopup table array)

The problem is I want to only keep Sheet A in the end but that's not possible because removing the Sheet B causes all the values to become #N/A. Any solutions?