How to view distinct values in a column?

[RayL]

Is there a way to view distinct values in a column (so that i can decide whether to keep/transform/delete this column)?

I don't see such an option in Query Editor > View

Thanks!

[ElenaN · Accepted solution]

Hello,

Do you need just to see the distinct values or you want a code to list them somehow or to make a count of duplicates if any?

If you just want to see distinct values of a column you can click on the down arrow of a column and it will show you, just like in Excel, a list of all distinct values. Another "viewing" option would be to do a Group by in Power Query by your column that will give you a list of all distinct values.

Otherwise, you have to be more specific about your needs.

Regards,

ElenaN

[RayL]

It worked. Thank you Elena for helping out a newbie 🙂