Copying multiple adjacent cells and pasting into non-adjacent cells

Occasional Visitor

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 Replies
add file and screenshots to see what you have and how you want it to work
You are not alone. I'm yet to see any solution to this. Now I'm considering going to Pandas for solution.