@MelissaTaylor With PowerQuery, this is a piece of cake. See attached file. Press the "Enable Content" button if you want to look into the query. I notice that there are duplicates in the second column. I left them for now, but they can be easily removed befor or after merging with the number in the first column.