Copying multiple adjacent cells and pasting into non-adjacent cells

Hello,

I've been working on an issue for a few hours now...I have two separate tables and am trying to transfer all of the data from a column in table 1 to non-adjacent cells in table 2, which I've filtered based on other values in the table. I've tried only selecting the visible cells (which is where I want to paste), but it seems that because I copied adjacent cells, it only pastes into adjacent cells, and the hidden cells end up being filled in anyways. Is there any way around this or do I need to paste each cell individually?

Any advice would be greatly appreciated!