I have a list of materials in column A. Some of the materials repeat in
various rows. I want to formula to summarize the list into a condensed list
of materials.

Many thanks in advance