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,
Solved! Go to Solution.
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
Great, Thank you!
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |