Multiple columns of data, want unique combinations

C

Coydog

New Member
Joined
Aug 7, 2017
Messages
4
I have multiple columns of data and want to create a unique combination of each column's data going down in rows. any thoughts?
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Coydog said:
I have multiple columns of data and want to create a unique combination of each column's data going down in rows. any thoughts?
Click to expand...

Maybe you could concatenate all of the target columns together in a helper column and then use advanced filter (unique) on the helper column.
 
Upvote 0
You mean like this?

B​
C​
D​
E​
4​
DumplingsKung Pao ShrimpFried riceFortune Cookie
5​
Egg rollOrange BeefSteamed riceIce Cream
6​
Wonton soupPork Lo MeinRice noodles
7​
Roast Duck
8​
Szechuan Chicken
9​
10​
DumplingsKung Pao ShrimpFried riceFortune Cookie
11​
DumplingsKung Pao ShrimpFried riceIce Cream
12​
DumplingsKung Pao ShrimpSteamed riceFortune Cookie
13​
DumplingsKung Pao ShrimpSteamed riceIce Cream
14​
DumplingsKung Pao ShrimpRice noodlesFortune Cookie
15​
DumplingsKung Pao ShrimpRice noodlesIce Cream
16​
DumplingsOrange BeefFried riceFortune Cookie
17​
DumplingsOrange BeefFried riceIce Cream
18​
DumplingsOrange BeefSteamed riceFortune Cookie
19​
DumplingsOrange BeefSteamed riceIce Cream
20​
DumplingsOrange BeefRice noodlesFortune Cookie
21​
DumplingsOrange BeefRice noodlesIce Cream
22​
DumplingsPork Lo MeinFried riceFortune Cookie
 
Upvote 0
You must log in or register to reply here.

Similar threads

V
  • Solved
simplest way in Excel to combine (merge)
Replies
4
Views
110
Fluff
Fluff
T
  • Question
Viewing data rows from another worksheet in a portal
Replies
1
Views
140
kevin9999
K
L
  • Question
build user list from spreadsheet
Replies
6
Views
121
lordriel
L
I
  • Question
Move multiple rows from one table to another using conditional trigger
Replies
2
Views
469
ItsNursinTime
I
L
  • Solved
Count of Unique Values in a Column of data with Comma Delimitted, Multiple Cell Values
Replies
5
Views
107
Fluff
Fluff

Forum statistics

Threads
1,215,043
Messages
6,122,822
Members
449,096
Latest member
Erald

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top