Look Who it Was Random video

Excel - Data Consolidation in Microsoft Excel: Combine Multiple Data Sets with Ease - Episode 786

982 views · Published 15 January 2009 · 2:27 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Data Consolidation in Microsoft Excel: Combine Multiple Data Sets with Ease.

Welcome back to the MrExcel netcast! In today's episode, we're going to dive into the world of data consolidation. This feature has been around for a while, but with the rise of pivot tables, it may have fallen off your radar. However, it still has its place and can be a powerful tool in your data analysis arsenal.

Before we get into the nitty-gritty of data consolidation, I want to address a question that came in from one of our viewers. We'll tackle that in tomorrow's episode, but for now, let's focus on understanding and utilizing data consolidation.

To demonstrate this feature, I have two separate data sets with sales reps and time periods. The first set has Q1, Q2, and Q3, while the second set has Q3 and Q4. Our goal is to combine these two sets into one, with all the unique sales reps and time periods accounted for.

To do this, we'll use the DATA and CONSOLIDATE command. By specifying the references for each data set and selecting the option to use labels in the top row and left column, we can easily consolidate the data into one superset. This means that all the time periods from both sets will be included, and any duplicate sales reps will have their values added together.

As you can see, the CONSOLIDATE command is a powerful tool that can save you time and effort when dealing with multiple data sets. We'll be discussing more about this feature in tomorrow's netcast, so be sure to tune in. Thank you for watching, and we'll see you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


An introduction to using Data Consolidate to add two data sets. Episode 786 introduces the concept. Tomorrows episode will throw in an interesting twist.

Table of Contents:
(00:00) Introduction to data consolidation
(00:22) Explanation of data consolidation
(00:32) Example of data consolidation
(01:00) Steps to use data consolidation
(01:43) Results of data consolidation
(01:59) Importance of data consolidation
(02:09) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Combining multiple data sets in Excel
Consolidating data with labels in top row and left column
Consolidating data with pivot tables
Data consolidation tutorial
Excel data consolidation feature
Exploring the DATA CONSOLIDATE command in Excel
How to consolidate data in Excel
MrExcel netcast on data consolidation
Understanding the power of data consolidation
Using data consolidation in Excel
Using the consolidate command in Excel
YouTube video on data consolidation


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152083/

More from this channel