Index repeating employee names to create Employee ID

[Justas4478]

Hi, I am trying to add new column to my table that serve as Employee ID since there is no in the data.

The only problem is that name repeats multiple times because of data. I know how it can be done if I dublicate table and remove other columns and dublicates.
But I was hoping it can some how be done without needing to do that. Maybe some conditional column.

Thanks.

[mussaenda · Accepted solution]

Hi @Justas4478 ,

you can group your data by Employee name, and before expanding, add an index column. then expand.

I attached a sample file