How could we combine values in columns excluding duplicates (column-wise) and blanks? Duplicate check on column-wise only, not row-wise. Below is an example scenario.
Please advise how we can achieve this. Sequencing of combined items not much important. There may be a preferred sequence to get, however not a showstopper or mandatory.
Thanks in advance.
Note: simplified the initial question to avoid confusion.
Please advise how we can achieve this. Sequencing of combined items not much important. There may be a preferred sequence to get, however not a showstopper or mandatory.
Thanks in advance.
Note: simplified the initial question to avoid confusion.
A | B | C | D | DesiredOutcome |
Apple | Orange | Apple | Apple;Orange | |
Orange | Orange | Orange | ||
Mango | Apple | Mango;Apple | ||
Orange | Mango | Mango | Apple | Organe;Mango;Apple |
Last edited: