software

I am trying to figure out how I can sort these rows and then combine the like
rows. Obviously, I am not describing it well, but this is what I want:

Start with:

Column (A) Qty per system; (B) # of Systems; (C) Total Qty (D) Part #; (E)
Part Description

1 2 2 W0000 Widgets
1 3 3 G0000 Gidgets
1 4 4 D0000 Didgets
1 2 2 W0000 Widgets
1 2 2 W0000 Widgets
1 3 3 G0000 Gidgets
1 4 4 D0000 Didgets
1 2 2 W0000 Widgets

I can sort and end up with:

1 2 2 W0000 Widgets
1 2 2 W0000 Widgets
1 2 2 W0000 Widgets
1 2 2 W0000 Widgets
1 3 3 G0000 Gidgets
1 3 3 G0000 Gidgets
1 4 4 D0000 Didgets
1 4 4 D0000 DidgetsWhat I want to do is combine the like part numbers; add the qtys and end up
with this:
A B C D E
1 2 8 W0000 Widgets
1 3 6 G0000 Gidgets
1 4 8 D0000 Didgets

The only number I am really concerned about combining is the total qty. (C)
The rest is irrelevant. Is this do-able? If so, I would sure appreciate a
detailed method of getting this done. Please keep in mind that I am
relatively new to Excel. Thank you in advance.

After you sort the data, try Data|subtotals (twice).

Or you may want to learn a bit about data|Pivottable.

LaNaye wrote:
gt;
gt; I am trying to figure out how I can sort these rows and then combine the like
gt; rows. Obviously, I am not describing it well, but this is what I want:
gt;
gt; Start with:
gt;
gt; Column (A) Qty per system; (B) # of Systems; (C) Total Qty (D) Part #; (E)
gt; Part Description
gt;
gt; 1 2 2 W0000 Widgets
gt; 1 3 3 G0000 Gidgets
gt; 1 4 4 D0000 Didgets
gt; 1 2 2 W0000 Widgets
gt; 1 2 2 W0000 Widgets
gt; 1 3 3 G0000 Gidgets
gt; 1 4 4 D0000 Didgets
gt; 1 2 2 W0000 Widgets
gt;
gt; I can sort and end up with:
gt;
gt; 1 2 2 W0000 Widgets
gt; 1 2 2 W0000 Widgets
gt; 1 2 2 W0000 Widgets
gt; 1 2 2 W0000 Widgets
gt; 1 3 3 G0000 Gidgets
gt; 1 3 3 G0000 Gidgets
gt; 1 4 4 D0000 Didgets
gt; 1 4 4 D0000 Didgets
gt;
gt; What I want to do is combine the like part numbers; add the qtys and end up
gt; with this:
gt; A B C D E
gt; 1 2 8 W0000 Widgets
gt; 1 3 6 G0000 Gidgets
gt; 1 4 8 D0000 Didgets
gt;
gt; The only number I am really concerned about combining is the total qty. (C)
gt; The rest is irrelevant. Is this do-able? If so, I would sure appreciate a
gt; detailed method of getting this done. Please keep in mind that I am
gt; relatively new to Excel. Thank you in advance.

--

Dave Peterson

Hi there
Have a look at the Subtotals command on the Data menu - should do what you
want I think. First sort the table on Part, then choose the command.
1st box should say 'at exch change in' PART
Then use the Count function in the 2nd box and in the last box tick the
fields you want values for. Hope it works

Sheila

quot;LaNayequot; wrote:

gt; I am trying to figure out how I can sort these rows and then combine the like
gt; rows. Obviously, I am not describing it well, but this is what I want:
gt;
gt; Start with:
gt;
gt; Column (A) Qty per system; (B) # of Systems; (C) Total Qty (D) Part #; (E)
gt; Part Description
gt;
gt; 1 2 2 W0000 Widgets
gt; 1 3 3 G0000 Gidgets
gt; 1 4 4 D0000 Didgets
gt; 1 2 2 W0000 Widgets
gt; 1 2 2 W0000 Widgets
gt; 1 3 3 G0000 Gidgets
gt; 1 4 4 D0000 Didgets
gt; 1 2 2 W0000 Widgets
gt;
gt; I can sort and end up with:
gt;
gt; 1 2 2 W0000 Widgets
gt; 1 2 2 W0000 Widgets
gt; 1 2 2 W0000 Widgets
gt; 1 2 2 W0000 Widgets
gt; 1 3 3 G0000 Gidgets
gt; 1 3 3 G0000 Gidgets
gt; 1 4 4 D0000 Didgets
gt; 1 4 4 D0000 Didgets
gt;
gt;
gt; What I want to do is combine the like part numbers; add the qtys and end up
gt; with this:
gt; A B C D E
gt; 1 2 8 W0000 Widgets
gt; 1 3 6 G0000 Gidgets
gt; 1 4 8 D0000 Didgets
gt;
gt; The only number I am really concerned about combining is the total qty. (C)
gt; The rest is irrelevant. Is this do-able? If so, I would sure appreciate a
gt; detailed method of getting this done. Please keep in mind that I am
gt; relatively new to Excel. Thank you in advance.

Sheila,

Thank you very much - it works! I did have to use SUM function instead of
COUNT because I wanted the total number of parts. Thank you for your help.

LaNayequot;Sheila Dquot; wrote:

gt; Hi there
gt; Have a look at the Subtotals command on the Data menu - should do what you
gt; want I think. First sort the table on Part, then choose the command.
gt; 1st box should say 'at exch change in' PART
gt; Then use the Count function in the 2nd box and in the last box tick the
gt; fields you want values for. Hope it works
gt;
gt; Sheila
gt;
gt; quot;LaNayequot; wrote:
gt;
gt; gt; I am trying to figure out how I can sort these rows and then combine the like
gt; gt; rows. Obviously, I am not describing it well, but this is what I want:
gt; gt;
gt; gt; Start with:
gt; gt;
gt; gt; Column (A) Qty per system; (B) # of Systems; (C) Total Qty (D) Part #; (E)
gt; gt; Part Description
gt; gt;
gt; gt; 1 2 2 W0000 Widgets
gt; gt; 1 3 3 G0000 Gidgets
gt; gt; 1 4 4 D0000 Didgets
gt; gt; 1 2 2 W0000 Widgets
gt; gt; 1 2 2 W0000 Widgets
gt; gt; 1 3 3 G0000 Gidgets
gt; gt; 1 4 4 D0000 Didgets
gt; gt; 1 2 2 W0000 Widgets
gt; gt;
gt; gt; I can sort and end up with:
gt; gt;
gt; gt; 1 2 2 W0000 Widgets
gt; gt; 1 2 2 W0000 Widgets
gt; gt; 1 2 2 W0000 Widgets
gt; gt; 1 2 2 W0000 Widgets
gt; gt; 1 3 3 G0000 Gidgets
gt; gt; 1 3 3 G0000 Gidgets
gt; gt; 1 4 4 D0000 Didgets
gt; gt; 1 4 4 D0000 Didgets
gt; gt;
gt; gt;
gt; gt; What I want to do is combine the like part numbers; add the qtys and end up
gt; gt; with this:
gt; gt; A B C D E
gt; gt; 1 2 8 W0000 Widgets
gt; gt; 1 3 6 G0000 Gidgets
gt; gt; 1 4 8 D0000 Didgets
gt; gt;
gt; gt; The only number I am really concerned about combining is the total qty. (C)
gt; gt; The rest is irrelevant. Is this do-able? If so, I would sure appreciate a
gt; gt; detailed method of getting this done. Please keep in mind that I am
gt; gt; relatively new to Excel. Thank you in advance.