Use the Consolidate Feature to Combine Data

Do you want to combine tables together? Lets say you have sales data that span multiple columns but there rows and rows of values. Also there are multiple worksheets (or tabs) that have the same format. The only difference is that one worksheet if for salesperson A and the other worksheet is for salesperson B. Now with two sales people the act of combining this together would be a simple copy/paste. However if you have more sales people (like 10, 15, or more!), that would be a lot of copying and pasting.  Instead of doing that, just use the consolidate feature in Excel to do the heavy lifting.  See how it's done with this video.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[stepyvoice]

I love how you explain that in details man you the best

[meundianand]

Very crisp and clear presentation.Thank you.

[muhammadbhatti]

Really very nice video and easy to use

[aljack]

Great video. Clear, simple and to the point!!

[edwinekine]

this video is wonderful, it has truly help me in my office work.

[chungtimothy]

excellent and clean clear presentation

[khandesikitchen]

impressive teaching and easy to learn.
thanks alot

[manishpanchal]

impressive teaching and easy to learn.
thanks a lot. KEEP IT UP. Buddy.

[manpreetkaur]

Thank you sir, it was good learning video for learning consolidate  tool :)

[SamiKhan-tbwn]

Thanks alott.. may God blesss u for ur effort and please do more education charity..

[bonifaceebineng]

Thanks a lot, got what i was looking for.

[devendrapnchal]

thanks a lot....!
it is really working if u have any video related excel pls update

[pearhossain]

It is really helpful.
could you please create a video showing VLOOKUP function with multiple application?

[CaseyChronicle]

Great video hawmie, enjoyed it alot, Keep the content coming!!:)

[saif-niqf]

Hi Doug! I would like to know if it works in case if the column names are different?

[pasungilsubbanasari]

Hi,
It cleared my doubts for totaling the multiple sheets. Very explanatory, Thank You for your nice works.
S PASUNGILI, DINDIGUL, SAP INFOTECH.

[DM-rtfq]

Hi

Thanks for your video.I have data which contains medical, institutions, furniture shops, doctors and much more.And the data is in laws and it is a single sheet.I am unable to separate by its category.

Can you help me how to do this.Please please.

[rajeshrawat]

Hi Doug.. just one question will this also able to take care of rows. if few number of rows are different in data sets.

[MarkdComment]

Hi Doug H, do you know how to do this in Numbers? It does not have the tools like Excel

[minterno]

You forgot to add Asia (2) in your second example, but I loved the tutorial, thank you so much!