Copy information for missing cells in a column that already exists in duplicate

Hello everyone,

I been learning a lot from this forum about excel but have found a problem I haven't been able to find the answer for, so any help is really appreciated.

I have conditional formatting that changes a whole row based on certain texts entered into cells found in my column H (genre). I get new raw data that I paste into my spreadsheet which will have duplicate values in other columns except for in this column H, which will be blank. Thing is I don't want to delete the duplicates, as some of the values in other cells are different. Based on all duplicates on column D(url) I want the Column H information to be copied into them, based on the one duplicate that has had its Coulmn H information filled, and then (hopefully) my conditional formatting should kick in as per usual and they will be highlighted to the same rule.

Hope that was explained okay

I have attached a screenshot to show my sheet. Hope its allowed. thanks

\1