I want to add “0” in OpenAmount when Document No are the same number and leave actual amount in only one row. This is the original excel file.
I want the excel like this. Adding “0” in other rows and leave actual amount in only one row when the Document No are the same.
I attached the sample excel file for reference. If you have any solution, please provide me. Many Thanks.
Book1.xlsx (8.3 KB)