Hello everyone,
I would like to know if there is any tool/configuration that I can use in order to eliminate some data from specific columns based on a rule. As an example I will attached you an excel file and also some details about it:
I have 5 lines: 2 for one billing document and 3 for another. Almost all of the data are the same except S&T and I would like to keep only one line with all the information and on the other lines just the data from S&T. For some of the Documents I can have 3 4 5 6 7 line with same data and online S&T to be different.
Thank you in advance !
Solved! Go to Solution.
Thank you so much @atcodedog05 . This works perfect! I will test it on a big data file in order to see if there is everything ok.
Happy to help : ) @mihaicom20
Cheers and have a nice day!