You may want to try the using "Subtotal" in the Data menu. If you use subtotals, you will have to ensure that your data is sorted, as you will get a subtotal for each new set of data in the column you specify. Your rows won't actually combine, but you will be able to get a row with totals you need. Using subtotals also will allow you to "hide" the underlying data using the options that will appear on the left hand side of the screen. Good luck.
A tricky one, at least to me. I have several rows for a company, where two cols are the same in each row, but the remaining cols vary. This will be converted to mySQL eventually, but it needs to be mangeable in Excel for now.
Rather than trying to explain it in words, I have posted a small (13K) sample file (confirmed virus-free, but pls check it yourself, too) :
The real-world scenario is that each company in the file carries certain types of products. Right now, each type of product is flagged in a separate row for that company. I need to combine those flags into a single row.
I'm scratching my head over this one trying to play with macros & formulas . . . I could do it in moments in SQL, but am not an Excel expert by any means.
Any help will be *greatly* appreciated !