data manipulation question

Hi

I’m trying to create a new column called “Data ID” to add to my data as in the example below. It seems like I need to count the data for each name then do some string manipulation to modify the data in the ID column, but I couldn’t figure it out. Thanks.