Please does anyone know if I can use pivot table to bring out unique values.
I have thousands of rows and columns with firstname, middlename and lastname.
Some names are duplicate and I just want to bring out only unique names.