Question: how do i copy filtered data from one column to another in excel?
Answer: Select the cells that you want to copy For more information, see Select cells, ranges, rows, or columns on a worksheet. ... 
Click Home > Find & Select, and pick Go To Special.
Click Visible cells only > OK.
Click Copy (or press Ctrl+C).