Best Practices

[Simon1187]

 Hi everyone. 

I hope you are well. 

I want to find duplicates in a table and show them side by side in another table. In the  table  want to check for phone number as a duplicate. Could you please help me. 

I have attached the table as a sample and the ideal result. 

Thanks,  

[Luke_C]

Hi @Simon1187 

Here's how I'd approach this:

1. Transpose data to get all phone numbers in one column
2. Remove null values
3. Unique tool to remove duplicates
4. Join Unique/duplicate records on phone number
5. The J output will show you which contact IDs have the same phone number
6. The L output will show you contacts that did not have a duplicate. 

[Simon1187]

Hi @Luke_C 

Thank you very much.  I really appreciate your help. 

[Luke_C · Accepted solution]

@Simon1187 happy to help! If it's all set please mark my response as the solution. This helps people in the future find it in search results easier