Hello. I need to copy a column (vertical) within 1 spreadsheet that has over 1000 cells to another spreadsheet that I filtered to have the same amount of cells (I hope it does have the same amount of cells).

The column of cells in spreadsheet 1 has formulas, but I only need the value, so I do a special paste and click only value show. But when I do paste it on the new spreadsheet, it does not completely copy the column. I realized that it does not copy any values that repeat (ex: the column of cells has these values: .01, .01, .02, .01, .03, .02, .03 ; and when I copy/special paste them in a new column in another spreadsheet, it only pastes .01,.02,.03)

I would not like to do this manually, so any help would be greatly appreciated! Thank you