Copying multiple adjacent cells and pasting into non-adjacent cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2312627%22%20slang%3D%22en-US%22%3ECopying%20multiple%20adjacent%20cells%20and%20pasting%20into%20non-adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2312627%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20working%20on%20an%20issue%20for%20a%20few%20hours%20now...I%20have%20two%20separate%20tables%20and%20am%20trying%20to%20transfer%20all%20of%20the%20data%20from%20a%20column%20in%20table%201%20to%20non-adjacent%20cells%20in%20table%202%2C%20which%20I've%20filtered%20based%20on%20other%20values%20in%20the%20table.%20I've%20tried%20only%20selecting%20the%20visible%20cells%20(which%20is%20where%20I%20want%20to%20paste)%2C%20but%20it%20seems%20that%20because%20I%20copied%20adjacent%20cells%2C%20it%20only%20pastes%20into%20adjacent%20cells%2C%20and%20the%20hidden%20cells%20end%20up%20being%20filled%20in%20anyways.%20Is%20there%20any%20way%20around%20this%20or%20do%20I%20need%20to%20paste%20each%20cell%20individually%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20would%20be%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2312627%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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!

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