Remove item from list which on is multiple time in list

Remove item from list which on is multiple time in list

This is the item list of a module. Here is an item multiple times in list. I want to match item ID and rate if an item is found more than once then I will keep one item there and remove the rest. And the total quantity of all matched items that an item is placed before removing will be saved. If there is an item 3 times, I will leave one there and remove the remaining 2, the remaining 2 will be removed and their quantity will be added with this item which will be in the list. After that I will update the new list again with the data of that module. Is it possible to do this with deluge script? I have tried but I could't. I have attached an attachment of the data list here. I will be happy if someone helps.

    Zoho Marketing Automation
            • Sticky Posts

            • Zoho CRM - Upcoming Features ...

              Hi, We would like to inform you about the Zoho CRM features that we are taking up in the near future.  Please go through this link. As a policy we will not commit any dates for any mentioned features. However we will try to roll out  the listed features one by one in the period of 6 months time. We will keep you posted just in case we change our priorities with respect to any features.  Thank you, With Best Regards, Dilip, Zoho CRM
            • Track and monitor sales activities with the all new Tasks, Calls, and Meetings modules

              This change will be available soon to all organizations. Hello everyone! Sales activities provide more context for where each deal is headed, helping sales reps to focus on accelerating the customer journey and close the deal. That is why it is critical
            • [Early Access - Updated to LIVE] Introducing the Canvas Design Studio.

              Greetings Customers!   Before we kick back and enjoy the holidays, we'd like to make a post about our next big thing. In January 2021, Zoho CRM will be launching its magnum opus for delivering world-class user experience - here's a sneak peek of what's
            • Introducing Multiple Sandbox Types and Support for Module's Data Population

              Register here for the upcoming Focus Group webinar on Multiple Sandbox | Help documentation to learn more about the new enhancements Hello everyone,  Sandbox in CRM is a testing environment for users to create and test new configurations like workflow
            • Include Finance Suite modules to Segment your records

              Dear All, Greetings! We have a quick update on Segmentation in Zoho CRM. Let's go! As you might know, Segmentation is a process of categorizing your customer records based on common patterns and behaviors. And, RFM is one such way to categorize customers

            Zoho Pagesense Resources

              Zoho SalesIQ Resources



                    Zoho TeamInbox Resources

                      Zoho DataPrep Resources



                        Zoho CRM Plus Resources

                          Zoho Books Resources


                            Zoho Subscriptions Resources

                              Zoho Desk Resources

                                Zoho Projects Resources


                                  Zoho Sprints Resources


                                    Qntrl Resources


                                      Zoho Creator Resources


                                        Zoho WorkDrive Resources




                                            Zoho Campaigns Resources

                                              Zoho CRM Resources

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now