I have a list of codes that are each assigned to a specific bigger case code and I would like to put a list all of the smaller codes that share one bigger case code in one cell. for example
D2-D6 are a 01 02 03 04 05 and C2-C3 is 1
- I want to group all the codes in the D column that share a 1 figure in the C column so the cell of my dreams would read "01,02". Any ideas on how to make this happen?