Multiple columns of data, want unique combinations

[Coydog]

I have multiple columns of data and want to create a unique combination of each column's data going down in rows. any thoughts?

 

[Gary McMaster]

I have multiple columns of data and want to create a unique combination of each column's data going down in rows. any thoughts?

Maybe you could concatenate all of the target columns together in a helper column and then use advanced filter (unique) on the helper column.

 

[shg]

You mean like this?

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]Dumplings[/td][td]Kung Pao Shrimp[/td][td]Fried rice[/td][td]Fortune Cookie[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]Egg roll[/td][td]Orange Beef[/td][td]Steamed rice[/td][td]Ice Cream[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]Wonton soup[/td][td]Pork Lo Mein[/td][td]Rice noodles[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td][/td][td]Roast Duck[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td][/td][td]Szechuan Chicken[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td="bgcolor:#909090"][/td][td="bgcolor:#909090"][/td][td="bgcolor:#909090"][/td][td="bgcolor:#909090"][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]Dumplings[/td][td]Kung Pao Shrimp[/td][td]Fried rice[/td][td]Fortune Cookie[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td]Dumplings[/td][td]Kung Pao Shrimp[/td][td]Fried rice[/td][td]Ice Cream[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td]Dumplings[/td][td]Kung Pao Shrimp[/td][td]Steamed rice[/td][td]Fortune Cookie[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]Dumplings[/td][td]Kung Pao Shrimp[/td][td]Steamed rice[/td][td]Ice Cream[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

14​

[/td][td]Dumplings[/td][td]Kung Pao Shrimp[/td][td]Rice noodles[/td][td]Fortune Cookie[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

15​

[/td][td]Dumplings[/td][td]Kung Pao Shrimp[/td][td]Rice noodles[/td][td]Ice Cream[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

16​

[/td][td]Dumplings[/td][td]Orange Beef[/td][td]Fried rice[/td][td]Fortune Cookie[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

17​

[/td][td]Dumplings[/td][td]Orange Beef[/td][td]Fried rice[/td][td]Ice Cream[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

18​

[/td][td]Dumplings[/td][td]Orange Beef[/td][td]Steamed rice[/td][td]Fortune Cookie[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

19​

[/td][td]Dumplings[/td][td]Orange Beef[/td][td]Steamed rice[/td][td]Ice Cream[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

20​

[/td][td]Dumplings[/td][td]Orange Beef[/td][td]Rice noodles[/td][td]Fortune Cookie[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

21​

[/td][td]Dumplings[/td][td]Orange Beef[/td][td]Rice noodles[/td][td]Ice Cream[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

22​

[/td][td]Dumplings[/td][td]Pork Lo Mein[/td][td]Fried rice[/td][td]Fortune Cookie[/td][/tr]
[/table]

 

[Coydog]

Yes exactly

 

[shg]

Workbook at https://app.box.com/s/47b28f19d794b25511be

 

[Coydog]

Perfect! Much appreciated

 

[shg]

You're welcome.