Make sure that your columns have headers, insertng a new row 1 if
necessary, then use Advanced Filter. Debra Dalgleish shows how he

http://www.contextures.com/xladvfilter01.html#FilterUR

Hope this helps.

Pete

On Dec 9, 12:31*am, tomhelle
wrote:
I have a long list of various components that I want to summarize. For example:

Column A * * * * * * * * * * *Column B
Material 1 * * * * * * * * * * Thickness 1
Material 1 * * * * * * * * * * Thickness 2
Material 2 * * * * * * * * * * Thickness 1
Material 1 * * * * * * * * * * Thickness 1

I want to summarize this data so that it will produce a list as follows:

Column A * * * * * * * * * * *Column B
Material 1 * * * * * * * * * * Thickness 1
Material 1 * * * * * * * * * * Thickness 2
Material 2 * * * * * * * * * * Thickness 1

Many thanks in advance!