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

Related Excel Tutorials