Check 2 Columns for duplicate values and Combine into Parent Child
I have a sheet where we capture name and e-mail. I want to check the sheet to see of these match and if they do, combine the duplicates into a parent child relationship with the first entry being the parent. I already capture the creation information so establishing the first entry should not be a problem.
Help Article Resources
Check out the Formula Handbook template!