Hello, I want to print the records which are duplicates based on a Primary Key,if the key is duplicated I want to print the record with its each occurance.
I tried grouping by Key and then taking a count of each group and then including all Count>1. This trick works if I just want to see...
How to convert following data to a matrix as shown below:
Data:
a a b c d e
b a b c d e
c a b c d e
d a b c d e
e a b c d e
to Matrix below:
a b c d e
b a c d e
c b a d e
d c b a e
e d c b a
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.