Combining common values

S

shuyin

New member
Joined
Aug 11, 2016
Messages
26
Reaction score
0
Points
0
Excel Version(s)
2016
Hello,

I have a field, which contains several values as below:
A, B
D, E, F
A, C
B, C
D, E, G


How can I group them together into a common group? Result as below:
A, B, C
D, E, F, G
A, B, C
A, B, C
D, E, F, G

Thank you,
 
Anyone could help pls?
 
I would gladly help if I had a clue what you were trying to achieve.

Attach a workbook with more realistic dummy data. In the workbook, manually mock-up the before and after scenarios.
 
AliGW said:
I would gladly help if I had a clue what you were trying to achieve.

Attach a workbook with more realistic dummy data. In the workbook, manually mock-up the before and after scenarios.
Click to expand...

View attachment Combine common values.xlsx

Attachment is the excel file.
Basically, it requires a function to search for any common value, and add the other non-common value into the same group. Eg. {A, B} has one common value with {B, C} --> common group is {A, B, C}
or {D, E, F} vs {E, F, G} --> {D, E, F, G}

Let me know if any other unclarity.
Thanks
 
I'm sorry - I don't know how to do this. I suspect you will need VBA rather than Power Query.
 
You must log in or register to reply here.
Back
Top