Remove duplicates keeping different values

HI,

I am fairly new at this, and not sure if this feature is available. 

I need to develop a PBI Dashboard that conects diferent data from multiple databases, but one of those just has available a faulty extraction that duplicates the registries given that a multiple option variable has two values checked. What I need is to remove the duplicate registries without loosing the multiple variable values that caused the duplication in the fiert place.

Below is an example of one of the duplicate registries in the original excel file.

As you can see, Div_fis and Calz_fis have two values cheked, therefore cuadrupling the registry. What I need is to merge those registries in some way, could be concatenating de duplicates only when the values are different grouping by the ID, or something like that but I don't know how to do it.

Please Help!

Thanks 

C.

PD: 

I've tried gruping by ID, and then using the table.column comand to extract the column, but it will concatenate the values that are the same, as "provincia" in the example above.