How to copy values only from a column to another from a filtered database

So I just had a unique combination of problems and solutions.

1 Large Database: Couldn’t use Google Sheets and had to sort to view qhat I was working on

2 Filthy data that needed sanitation so I created a formula in a helper column to clean it up

So I created a helper column for the helper column to paste the formulas as values but you can’t paste to columns if youve filtered, so what I did is color fill the rows I was working on (just in case so I didn’t lose my work) and then removed the filter, then copy over the formula column into the new helper column as values, and deleted the formula column, then filtered back by color to get to the rows I was working on, and did a trick I learned on Reddit of selecting all the rows I was working on, press alt + ; and then Home > Fill > Fill to the left, since my helper column was to the right, this finally, copied over the values only to the column without overwriting any other values other than the filtered ones. Posted as a tip but if anyone has a better way LMK!