Removing specific cells from an excel based on condition

[mihaicom20]

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 !

[atcodedog05 · Accepted solution]

Hi @mihaicom20 

Here is how you can do it.

Workflow:

Hope this helps : )

[mihaicom20]

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.

[atcodedog05]

Happy to help : ) @mihaicom20 

Cheers and have a nice day!