Solution by Tom Prowse and you can download the workflow here . Step 1 - Split Users First up we want to split the users field so that we have a separate row for each user. Currently, they are all in a single row and are separated by a ','. Therefore, we can use the custom split functionality to break these into separate fields: From here we can remove the original field and then pivot the split fields using a Columns to Rows and the word 'users' as the wildcard option: At this stage we can rename the Pivot Values to User and then start to create some IDs from the user data. User ID LEFT([Users],7) Private or Dealer RIGHT([Users],1) Then we want to keep only the 'D' for Dealers. Dealership ID MID([Users],8,3) At this stage our Users table should now look like this: Step 2 - Combine Ads Data Once we have input the Ads data, we can then remove any null values from the sale_date field and make sure it's a Date field type. We can then join this to our us