Combining two rows of information.....

  • Thread starter Thread starter cwangosu
  • Start date Start date
C

cwangosu

My main purpose is to sort items wihich are used the most often.
Right now , hoewever, usage for from. Right now, some items even
though they are in the same location(what we're worried about) , are
in sepearate rows in this Excel spreadsheet due to the fact that
sometimes they're used as an entire box or just as single items.
We're not worried about that, what we're worried about is how many
tmimes a worker needs to go to this location. Therefore, the two
sometimes three rows that have the same location, I'd like to combine.
their usage numbers. What would be the best function for this?

Here's what I want in a more programming language.
For (x=1 to 12000)
For (y=1 to 12000)
If Fx = Fy then combine Dx and Dy
 
Hi
could you post some example rows of your current data and the expected
result based on this example (plain text - no attachments please)
 
item_ no_picks uom locn_from
239930 34 PK A1-01-A-01
239930 10 EA A1-01-A-01
386066 3 BX A1-01-B-01
386066 1 CS A1-01-B-01
236173 15 PK A1-01-C-01
236173 2 EA A1-01-C-01
456487 2 BX A1-01-C-02
386068 2 BX A1-02-A-01
462515 15 EA A1-02-B-01

So in this sample data, Cells B2 and B3 should be combined, as well as
B4 and B5 & B6 and B7.
 
The simplest way would be using a pivot table to sum the number of picks
for each item
 
Back
Top