Hi! I’ve an excel table that is similar to this:

## | XXXX | YYYY | ZZZZ | AAAA | BBBB | CCCC |

## | Val.**1** | Val. 2 | Val. 1 | Val. **5** | Val. 9 | Val. 1 |

| Val.3 | Val. 3 | Val. 2 | Val. 8 | Val. 7 | Val. 3 |

| Val.6 | Val. 1 | Val. 3 | Val. 5 | Val. 5 | Val. 5 |

| Val.**1** | Val. 5 | Val. 6 | Val. **3** | Val. 2 | Val. 7 |

And what I want is to remove duplicated row entries lefting behind the first value. Like For the column **“XXXX”** I want to stay only with “Val.1 , Val.3, Val.6” removing the last row. And then in the column **“AAAA”** I want only to stay with “Val 5,Val.8”. At the end my table should look like this:

## | XXXX | YYYY | ZZZZ | AAAA | BBBB | CCCC |

## | Val.**1** | Val. 2 | Val. 1 | Val. **5** | Val. 9 | Val. 1 |

| Val.3 | Val. 3 | Val. 2 | Val. 8 | Val. 7 | Val. 3 |

Because the last and the third rows have duplicated values for the same column.

Any idea on how can I do this with a Datatable.Select ??