Hello, I have been trying to take an excel datatable and compare the values in a column, thereafter finding any repeat values in the column and deleting it in place. An example will be in the screenshot attached. ![ss|404x415]
I have tried a long winded method, but i am stuck now.
That is to go into the DatatableColumn -> for each row -> get the value of each cell and store it in an array_variable -> for each array_value, check if there is any duplicates in the array -> replace the value with something like " " -> rewrite it to the file.
I am stuck at the part in bold. May i know if there is anyway to do this?
Also appreciate if there is a complete shortcut to this