[58-4ever]

Originally Posted by CleveSteve

Select your data set

Insert a Pivot Table on a new sheet.

Drag your field which you need to be unique into the "Row labels" column.

That's it.

This!