Data with Mix of Unique and Duplicate IDs - Create new column that creates Unique IDs for all

I have a data set where I have a mix of unique and duplicate transaction IDs. I am trying to figure out a way to create a MACRO that can complete the following on different data extracts with the sam...