Unique values based on distinct values in a column

[chakrared]

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
value a	UNIQUE 1
value b	UNIQUE 2
value c	UNIQUE 3
value c	UNIQUE 3
value d	UNIQUE 4
value a etc....	UNIQUE 1

I stress again there are two many values to manually assign a unique value.

Any help really appreciated. Totally stuck.

[harshnathani]

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)