How to paste data in Non adjacent cells in a filtered table?

%3CLINGO-SUB%20id%3D%22lingo-sub-2016313%22%20slang%3D%22en-US%22%3EHow%20to%20paste%20data%20in%20Non%20adjacent%20cells%20in%20a%20filtered%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2016313%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20we%3CSTRONG%3E%20filter%20data%20in%20a%20table%3C%2FSTRONG%3E%20in%20excel%20workbook%2C%20its%20obvious%20that%20%3CSTRONG%3Esome%20rows%20will%20be%20hidden%3C%2FSTRONG%3E.%20My%20doubt%20is%20how%20can%20we%20copy%20data%20in%20adjacent%20cells%20and%20paste%20it%20in%20non%20adjacent%20cells%20(in%20a%20table%20for%20which%20filter%20is%20applied).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2016313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2016885%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20paste%20data%20in%20Non%20adjacent%20cells%20in%20a%20filtered%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2016885%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F912068%22%20target%3D%22_blank%22%3E%40asmfca%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20give%20a%20few%20more%20details%3F%20If%20at%20all%20possible%2C%20a%20copy%20of%20the%20data%20(or%20some%20resemblance%20of%20it%20if%20the%20real%20one%20contains%20confidential%20info)%20would%20help%3B%20not%20just%20an%20image%2C%20but%20an%20actual%20Excel%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20be%20specific%20about%20what%20isn't%20clear%3A%20how%20are%20you%20performing%20the%20filtering%20you%20speak%20of%3F%20There%20are%20several%20ways%20to%20do%20that.%20If%20you're%20using%20the%20fairly%20new%20FILTER%20function%2C%20then%20there%20are%20ways%20to%20filter%20individual%20columns%20separately....%20but%20if%20you%20could%20give%20some%20more%20info%20and%20a%20spreadsheet%2C%20you'd%20be%20helping%20us%20help%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

When we filter data in a table in excel workbook, its obvious that some rows will be hidden. My doubt is how can we copy data in adjacent cells and paste it in non adjacent cells (in a table for which filter is applied).

1 Reply

@asmfca 

 

Could you give a few more details? If at all possible, a copy of the data (or some resemblance of it if the real one contains confidential info) would help; not just an image, but an actual Excel spreadsheet.

 

To be specific about what isn't clear: how are you performing the filtering you speak of? There are several ways to do that. If you're using the fairly new FILTER function, then there are ways to filter individual columns separately.... but if you could give some more info and a spreadsheet, you'd be helping us help you.