Forum Discussion
[Analysing Duplicate Values] Comparing multiple rows for similar values across multiple columns
I am doing analysis of duplicate entries for a survey. I want to analyse the duplicates to determine which one to keep before deleting the rest of the entries. I was able to learn how to group th...
You can use Table.FuzzyGroup to accomplish this. This function will group similar column values together.
Start by unpivoting the data into attribute/value pairs (Question/value)
Then do a group on all the columns with a count rows
Finally, replace the Table.Group function with Table.FuzzyGroup function.