I am attaching Excel Worksheet, Which contains two sheet one is system generated file and second is Output which i want to achieve. for your easy understanding i have highlighted Cell and fond with colors. in system generated file there is several items which are repeated couple of times and transaction quantity of these items are differ. i want these items in output file only one time and sum of that particular item.
Bookmarks