I have a spreadsheet with a list of product stock #'s and descriptions. The product comes in sizes (shoe sizes), so there is a row for each product/size - for instance "m's adirondack blk 08.0, m's adirondack blk 08.5, m's adirondack blk 09.0" etc. This makes for a very long spreadheet, and I really only need a list of each style that it contains - "m's adirondack blk", not each size, thereby cutting the list for each style from 10 or 12 rows, to 1.
I have a feeling a pivot table could work, but how do I get it to show only the first of each product set? FYI, the stock # column for the example above would look something like "ABC12345-08.0, ABC12345-08.5, ABC12345-09.0, etc."

Any help would be appreciated!