Comparing Data in 10 Columns

Question

Hello,

Looking for a solution similar to EXACT but that only works for 2 columns of data. I have data in 10 columns that I need to compare for 400,000 lines of data on my employees. I just bought Kutools yesterday so I'm not very familiar with it yet. Is there a way for me to do this comparison? Blank cells should be excluded from the comparison and it does not need to be case-sensitive so a T is the same as a t.

Sample attached.