Office & Productivity Software forum

General discussion

Excel 2000 : Combining rows ?

by Glenn / April 21, 2004 4:44 AM PDT

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 !

Discussion is locked
You are posting a reply to: Excel 2000 : Combining rows ?
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Excel 2000 : Combining rows ?
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Re:Excel 2000 : Combining rows ?
by Bill / April 21, 2004 5:43 AM PDT

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.

Collapse -
Re:Excel 2000 : Combining rows ?
by JethroUK / April 21, 2004 6:03 AM PDT

C11 =SUM(($A$1:$A$8=$A11)*C$1:C$8)

Note: this is an array formula and must be entered using CTRL + SHFT + Enter

Then Drag as ness

Collapse -
Re:Re:Excel 2000 : Combining rows ?
by Glenn / April 21, 2004 8:31 AM PDT

Thanks for the replies.

Turns out we had to do it in SQL and trash the Excel compatibility. With 38K records, it wasn't feasible to go through inserting formulas; had to use a more automated process.

Thanks for the info, though. I'll retain for future reference.

Popular Forums
Computer Newbies 10,686 discussions
Computer Help 54,365 discussions
Laptops 21,181 discussions
Networking & Wireless 16,313 discussions
Phones 17,137 discussions
Security 31,287 discussions
TVs & Home Theaters 22,101 discussions
Windows 7 8,164 discussions
Windows 10 2,657 discussions

Does BMW or Volvo do it best?

Pint-size luxury and funky style

Shopping for a new car this weekend? See how the BMW X2 stacks up against the Volvo XC40 in our side-by-side comparison.