Google Sheets, Sort table based on unique values in a single column

Question

I am currently trying to use google sheets to sort a table based on the unique values found in only two of the columns.

What I want to happen is that columns A (Brand) and B (Dimensions) are both checked for unique values, removing any duplicate data.

The problem is using these two columns to filter and show the rest of table. I can't managed to achieve it.

Original Data

What is should look like after being culled

.

Answer 1

You can use Query function:

=query(A1:D8,"select A, B, min(C), min(D)  group by A, B",1)

Example spreadsheet