Forum Discussion
Unique values based on distinct values in a column
I have a problem where I need to generate a unique value for each unique value in a column. The column has throusands of rows and hundreds of unique values. EG Column A (text) Desired column ...
Hi chakrared ,
Please check this article which enables you to group similar values and generate an index using Power Query.
https://www.howtoexcel.org/power-query/grouped-serial-numbers-with-power-query/
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)