Automatically copy data from different columns to certain column skipping blank cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2310654%22%20slang%3D%22en-US%22%3EAutomatically%20copy%20data%20from%20different%20columns%20to%20certain%20column%20skipping%20blank%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310654%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20automatically%20gather%20data%20filled%20in%20columns%20in%20sheet1%2C2%2C3%20to%20sheet%204%20considering%20every%20category(Name%20Tel%20Number%20Amount)%20and%20skipping%20blank%20cells%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2310654%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2310728%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20copy%20data%20from%20different%20columns%20to%20certain%20column%20skipping%20blank%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041797%22%20target%3D%22_blank%22%3E%40Ismailz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20might%20be%20able%20to%20use%20the%20FILTER%20function%20to%20do%20that.%20Here's%20a%20video%20that%20explains%20its%20use%20very%20well.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThose%20source%20sheets%2C%20however%2C%20are%20worrisome%20to%20me%3A%20In%20general%20I%20would%20recommend%20making%20them%20simpler%20and%20more%20functional%2C%20by%20which%20I%20mean%2C%20in%20part%2C%20place%20less%20emphasis%20on%20aesthetics%20(colors%20and%20separations)%20and%20more%20on%20just%20creating%20a%20clean%20table%20of%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How to automatically gather data filled in columns in sheet1,2,3 to sheet 4 considering every category(Name Tel Number Amount) and skipping blank cells ?

1 Reply

@Ismailz 

 

You might be able to use the FILTER function to do that. Here's a video that explains its use very well.

https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Those source sheets, however, are worrisome to me: In general I would recommend making them simpler and more functional, by which I mean, in part, place less emphasis on aesthetics (colors and separations) and more on just creating a clean table of data.

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...