TO FIND OUT DIFFERNT VALUES IN AN ARRAY OF TWO COLUMNS

%3CLINGO-SUB%20id%3D%22lingo-sub-1589443%22%20slang%3D%22en-US%22%3ETO%20FIND%20OUT%20DIFFERNT%20VALUES%20IN%20AN%20ARRAY%20OF%20TWO%20COLUMNS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589443%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wanted%20to%20find%20out%20the%20different%20value%20in%20the%20second%20column%20if%20there%20are%26nbsp%3Brepetitions%20in%20the%20first%20column.%3C%2FP%3E%3CP%3EFor%20example%3C%2FP%3E%3CP%3Ea%20-%201%3C%2FP%3E%3CP%3Ea%26nbsp%3B-%26nbsp%3B2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1589443%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I wanted to find out the different value in the second column if there are repetitions in the first column.

For example

a - 1

a - 2

 

1 Reply
Highlighted
Hi, I think you should give us more details on what you are trying to achieve and how you are trying to achieve whether via out-of-box or custom coding.