The Consolidate tool in Excel is located in the Data menu and combines values from multiple ranges into one new range.

You would use this feature when you have a single text column on the left and the column has many duplicate values.

First you need to select a blank cell outside your data set and then go to Data > Consolidate.  You will then need to select all your data and make sure that the Top Row and Left column boxes are checked.

DOWNLOAD WORKBOOK

Consolidate

THIS POST WAS INSPIRED BY THE FOLLOWING BOOK:

gdacover

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Show The Percent Of With Excel Pivot Tables   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF calculation. It will display the value of one item (the Base Field) as the percentage of another item (the Base Item). This optio...
Fix Incorrect Formatting Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically. Ever had the scenario where your data is formatted differently? Example: First names starting wit...
Excel Hyperlinks: Buttons Excel´s hyperlink capability is amazing but many people don't use it as they don't know its full capabilities. With a hyperlink you can link an object/text to open an existing file on your desktop, go to a website, open up an email to a specific contact or go to a cell within ...
Drop Down Menu In Your Excel Table Apart from creating a simple Drop Down Menu/List or Data Validation List, you can expand this concept to include it in your Excel Table or Database. Watch how to insert a Data Validation List That way you don't have to do repetitive tasks like entering the same customer ov...