How to show distinct values in a separate column?

[Aliisa]

Hi!

How could I have a separate column that shows distinct values and dublicates?

The data that I want to analyze includes multiple rows for one ID and I want to filter dublicates away in the table.

[V-lianl-msft]

Hi @Aliisa ,

Could you paste sample data and the results you expect to let us know more about your scenario?

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[darshaningale]

Please provide input file and desired output.

[ribisht17]

Hi Alisa, Please post your data set so that we can help you, was just wondering if you just want to delete multiple entries within an ID which can be done like this