How to remove duplicate data

jmphillips

Hello community: I have a problem withe duplicate data, this is an example:


                                                Col 1                                                                                                                             Col 2
  

39-2021	49-2021
49-2021	39-2021

so I want to remove one of those rows.

Help please, you are my only hope.....

BalazsBaranyRM

Hi @jmphillips,

this sounds like a good use case for De-Pivot, removing the duplicates, and Pivot again.

De-Pivot will put all values into subsequent rows and keep the information about the column name (Col 1, Col 2) in another column. You would then remove the duplicates according to your rules and use Pivot to build the original data structure again. 

Be careful to remove entire "rows" (original rows, which are multiple rows after the De-Pivot). If you don't do that, you will have missing data upon pivoting again.

Regards,
Balázs