Duplicates Numerous Columns

davidgosselin

Hello everyone,

I have linked a sample example of my data set to the post with the desired outcome. Basically, I want to delete the columns where the data is the same in another column. I have hundreds of columns and therefore I would need something where i would not need to individually select columns.

Can someone help me with this matter ?

Thank you,

Duplicates.xlsx

danilang

Hi @davidgosselin 

You can do this by completely transposing your data twice

After the first container your data looks like this

in this form, a simple Unique tool configured with Assets Cash and Liabilities is all you need to remove the duplicate rows.  Completely transpose again and you get 

Dan

RemoveDuplicateColumns.yxzp