need to combine rows

[zazzz]

I put this up on another forum but havent gotten a response yet and need to get this project done today, so need to post again. Please forgive.

http://www.mrexcel.com/forum/excel-q...ml#post3482732


Excel Consolidate.jpg

I have about 10 columns: Prod#, Prod Desc, Qty Sold, Net Sales, Buyer Name, Week # etc etc.

Now each item in here has been mentioned multiple times. For example my spreadsheet tells me 10 units of Bread were sold in week 6, 3 in week 8, 5 in week 9, etc. Then it'll tell me everything for Cream, then Towels etc. I dont want all this. I just want to know what the TOTAL of each item sold was during the year.

This means I want all my columns to stay exactly the same, except for the ones which gives me the total sold that week (instead I want total for the year). And the week # can be removed.

I used the Subtotal function but even though that came close to giving me what I want, it didnt fix it. In the Subtotal rows it only had the numbers, not the descriptions that I wanted.

Help!

[oeldere]

You get better help if you add an excel file, without confidentional information.

Please also add the desired (expected) result.

Just a few lines will do, in the format you will use. (please do not add the whole file).

[zazzz]

OK here it is. Thanks.

[oeldere]

How about an pivot table.

See the attached file.

[zazzz]

I'm afraid not. I wanted it to look exactly the way I showed in the file above, looking like a normal spreadsheet. But I've just figured out how to do this. I first made a copy and removed duplicate values. Then I used a sumif formula to populate the totals. Done and done!

[oeldere]

I think it's a hell of a job if you got a lot data.

e.g. a lot of different buyers / a lot of differant weeks / months / quartal

In that case you get better (and easier) result using pivot table.

[zazzz]

I think it's a hell of a job if you got a lot data.

e.g. a lot of different buyers / a lot of differant weeks / months / quartal

In that case you get better (and easier) result using pivot table.

Possibly, but I was using this information for a very specific purpose, for a template at work. I wasnt looking to make it better. I did indeed use a pivot table later on, which was built into the template, but this had to be in the original format at this point.

Thanks for your help!

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[zazzz]

Yup its solved. I finally figured it out with the help of a friend. I explained my solution in post #5.