Forum Discussion
Clusters of data without a certain value
I have a file with couple hundred thousand rows of account clusters. We are using this life for de-duplication of accounts pulled from 4 databases. Each cluster on average is 6 rows of accounts eac...
Easy in PowerQuery. Data, From Table. Filter the column with the W by unchecking the W. Delete all but the cluster column. Now remove duplicates.