Microsoft Query Combining sheets problem

[RogueLeader]

Hello, I have a spreadsheet with multiple sheets which I am trying to consolidate.

The form is as below

Sheet1
ID Criteria1
1 A
1 B
1 C
2 D
2 E
2 F

Sheet2
ID Criteria2
1 Z
1 Y
1 X
2 W
2 V
2 U

When combining using a Query, I link the ID's between the tables, but I get an out put like this:

ID Criteria1 Criteria2
1 A Z
1 A Y
1 A X
1 B Z
1 B Y
1 B X
1 C Z
1 C Y
1 C X
2 D W
2 D V
2 D U
etc.

There are not necessarily the same number of lines for Criteria 1 and Criteria 2 and they don't relate to each other. I just need enough lines with the ID to contain whichever criteria has more

Is there a way to eliminate all the redundancy? or is there another method? I have thousands of lines of records like this so manual manipulation isn't feasible.

Thanks for any help.

[hoyasaxa215]

You want all unique combinations of ID, Criteria1, and Criteria2?