Formula That Returns Unique Combinations from Two Non-Contiguous Lists

[ExcelUser]

I need a formula that will return unique combinations of values from two non-contiguous lists

For example

Sheet2 contains my data range. Note that Column B has “—“ as it’s values in this example because I wish not to include them in the data range (and thus creating the “non-contiguous†scenario). Including the values in Column B would make every row combination of values unique and all data would be returned. I only wish to have the unique values of Columns A and C returned

Sheet2
A B C
1 CODE -- LOCATION
2 12345 -- 1 Main Stree
3 12345 -- 1 Main Stree
4 12345 -- 2 Dalton Road
5 12345 -- 2 Dalton Roa

Sheet1 (Columns A & B) will contain the formulas to return the unique row combinations of Sheet2 , Columns A and C

Sheet1
A
1 CODE LOCATIO
2 12345 1 Main Stree
3 12345 2 Dalton Roa

Thanks for your help

E