List each occurrence with a unique identifier based on type and frequency table

Hi All,    Got a bit of a tough one here - I'm trying to work out a formula which is able to identify each 'instance/occurance' or a type based on the frequency value within the table (essentially ...