Add new datatable column/row where there is a matching column value

I have 2 columns - Name & URL. These column store a client name the URL extension to that page.

I want to create a new column called CT_Name. This is a link that exists on each Name page that stores rows of CT_Names.

I want to loop through each URL row in my data table (works fine), navigate to the CT_Name page (currently using Navigate To and Click action which works fine) and then scrape the structured data to the new CT_Name column for each Name row.

But I want to make sure that the CT_Name rows are only added to the Datatable where the URL matches as there are multiple CT_Name entries for each Name.

How can I do this?

Thanks for your help :slight_smile: