How can I copy cell values rather than references from one sheet to another in Google Docs?

How can I copy cell values rather than references from one sheet to another? Right now using Filter, Query and ArrayFormula creates references which create empty cells and disallow sorting of the sheet.

I need the copy to only carry through values and not references.

Source: http://webapps.stackexchange.com/questions/33220/how-can-i-copy-cell-values-rather-than-references-from-one-sheet-to-another-in-g

mary poppins john derbyshire kinkade thomas kinkade paintings easter bunny navy jet crash virginia beach isiah thomas