Unique Combination of Two Lists

An Excel file that teaches how to perform Unique Combination of Two Lists operation.

Excel Dashboard for Unique Combination of Two Lists

Concatenated formulas combine data sets. Duplicate items are removed. Blank values are filtered out. The list is sorted alphabetically. Updates are automatically reflected.

Hope it is useful.