Aggregating rows based on the same unique ID

  • Re: Aggregating rows based on the same unique ID


    Could you kindly be more precise about what you call "aggregating" ...?

    Have you considered inserting a Pivot Table ... which would be the ideal solution for you ...

    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Re: Aggregating rows based on the same unique ID


    Thanks-I mean adding the amounts and vols where the code and delinquency fields are the same [per original attachment]

    I need to load the output into a system eventually so a pivot might not help.

  • [h=4] Combine Rows With Same ID/Name By VBA[/h]
    This method will introduce a VBA to quickly combine all rows with the same ID or name in the specified selection. Please do as follows:

    1. Press Alt + F11 keys to open the Microsoft Visual Basic for Applications window.

    2. Click Insert > Module, and then paste the VBA code into the Module window.

    Hope above information will help you. If you want to get more information about excel then you should go for advance excel training course.

  • @kritesh

    You have responded to a thread that was originated in August of 2017--almost 2 years ago. While we appreciate your response, it is highly unlikely the OP is still looking for an answer after this period of time. Please try and keep your responses more timely.

    Welcome to the Forum.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!