• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need help on consolidation

J

jayalaxmi

Active Member
Under DUNKELD WINE & LIQUOR you will notice there are several lines of duplicated items. Such as LACE BY ALMENKERK ROSE 750ml, FUSION V 750ml etc. Each of those lines have data numerical data on the right indicated units per month. With FUSION V 750ml for instance I'm trying to combine all the data in each duplicated product line to form a single line for FUSION V 750ml with all its numberical monthly also consolidated.

For each customer I must do the same, so I'm trying to find a function that will consolidate all duplicated product lines per customer.
 

Attachments

merging data across duplicate ranges


Under DUNKELD WINE & LIQUOR you will notice there are several lines of duplicated items. Such as LACE BY ALMENKERK ROSE 750ml, FUSION V 750ml etc. Each of those lines have data numerical data on the right indicated units per month. With FUSION V 750ml for instance I'm trying to combine all the data in each duplicated product line to form a single line for FUSION V 750ml with all its numberical monthly also consolidated.

For each customer I must do the same, so I'm trying to find a function that will consolidate all duplicated product lines per customer.
 
You must log in or register to reply here.
Back
Top