Listing rows based on unique column data.

For simplicity sake,   I have a 4 column sheet. Brand, Product, Salesman, Sales period.   I want to list all row data for: Unique brands sold AND unique brand & product sold AND (if multiple br...