Copying multiple adjacent cells and pasting into non-adjacent cells

[willyB284]

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!

[#2]

add file and screenshots to see what you have and how you want it to work

[#3]

You are not alone. I'm yet to see any solution to this. Now I'm considering going to Pandas for solution.