Hi all, you've been so helpful I had to throw this at you.

I have a table of data (see below).

You'll note there are multiple identical items in the 1st and 2nd
columns, the third being different

Is there an easy way to "squash" and consolidate the information,
summing the 3rd column and place it beside the corresponding items in
columns 1 and 2?


The (short version of ) the info:


016073217948 BETTY BALL EXP ENERG 11
016073217948 BETTY BALL EXP ENERG 0
016073217948 BETTY BALL EXP ENERG 2
016073217948 BETTY BALL EXP ENERG 1
016073217948 BETTY BALL EXP ENERG 23
016073217948 BETTY BALL EXP ENERG 29
018627175209 KASHI GOLEAN DRK VN4 2
018627175209 KASHI GOLEAN DRK VN4 2
000009022621 BOU OIL ROLL ON ASST 64
000009022621 BOU OIL ROLL ON ASST 29
000009022621 BOU OIL ROLL ON ASST 24
000009022621 BOU OIL ROLL ON ASST 110
000009022621 BOU OIL ROLL ON ASST 86
000009022621 BOU OIL ROLL ON ASST 13
000009022621 BOU OIL ROLL ON ASST 105
000009022621 BOU OIL ROLL ON ASST 52
000009022621 BOU OIL ROLL ON ASST 61
000009022621 BOU OIL ROLL ON ASST 2
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022638 BOU OIL MINARET ASST 11
000009022638 BOU OIL MINARET ASST 5
000009022638 BOU OIL MINARET ASST 7
000009022638 BOU OIL MINARET ASST 15
000009022638 BOU OIL MINARET ASST 21
000009022638 BOU OIL MINARET ASST 2
000009022638 BOU OIL MINARET ASST 19
000009022638 BOU OIL MINARET ASST 16
000009022645 BOU INCENSE REG ASST 12
000009022645 BOU INCENSE REG ASST 16
000009022645 BOU INCENSE REG ASST 8
000009022645 BOU INCENSE REG ASST 5
000009022645 BOU INCENSE REG ASST 31
000009022645 BOU INCENSE REG ASST 13
000009022645 BOU INCENSE REG ASST 1
000009022645 BOU INCENSE REG ASST 1
000009022652 BOU INCENSE GAR ASST 9

Hi,

with your example data in range A1:C39 use the following formula in
column D:

=SUMPRODUCT(($A$1:$A$39&$B$1:$B$39=A1&B1)*($C$1:$C$39))

Regards,
Ingolf



Oggie Ben Doggie schrieb:

> Hi all, you've been so helpful I had to throw this at you.
>
> I have a table of data (see below).
>
> You'll note there are multiple identical items in the 1st and 2nd
> columns, the third being different
>
> Is there an easy way to "squash" and consolidate the information,
> summing the 3rd column and place it beside the corresponding items in
> columns 1 and 2?
>
>
> The (short version of ) the info:
>
>
> 016073217948 BETTY BALL EXP ENERG 11
> 016073217948 BETTY BALL EXP ENERG 0
> 016073217948 BETTY BALL EXP ENERG 2
> 016073217948 BETTY BALL EXP ENERG 1
> 016073217948 BETTY BALL EXP ENERG 23
> 016073217948 BETTY BALL EXP ENERG 29
> 018627175209 KASHI GOLEAN DRK VN4 2
> 018627175209 KASHI GOLEAN DRK VN4 2
> 000009022621 BOU OIL ROLL ON ASST 64
> 000009022621 BOU OIL ROLL ON ASST 29
> 000009022621 BOU OIL ROLL ON ASST 24
> 000009022621 BOU OIL ROLL ON ASST 110
> 000009022621 BOU OIL ROLL ON ASST 86
> 000009022621 BOU OIL ROLL ON ASST 13
> 000009022621 BOU OIL ROLL ON ASST 105
> 000009022621 BOU OIL ROLL ON ASST 52
> 000009022621 BOU OIL ROLL ON ASST 61
> 000009022621 BOU OIL ROLL ON ASST 2
> 000009022621 BOU OIL ROLL ON ASST 1
> 000009022621 BOU OIL ROLL ON ASST 1
> 000009022621 BOU OIL ROLL ON ASST 1
> 000009022621 BOU OIL ROLL ON ASST 1
> 000009022638 BOU OIL MINARET ASST 11
> 000009022638 BOU OIL MINARET ASST 5
> 000009022638 BOU OIL MINARET ASST 7
> 000009022638 BOU OIL MINARET ASST 15
> 000009022638 BOU OIL MINARET ASST 21
> 000009022638 BOU OIL MINARET ASST 2
> 000009022638 BOU OIL MINARET ASST 19
> 000009022638 BOU OIL MINARET ASST 16
> 000009022645 BOU INCENSE REG ASST 12
> 000009022645 BOU INCENSE REG ASST 16
> 000009022645 BOU INCENSE REG ASST 8
> 000009022645 BOU INCENSE REG ASST 5
> 000009022645 BOU INCENSE REG ASST 31
> 000009022645 BOU INCENSE REG ASST 13
> 000009022645 BOU INCENSE REG ASST 1
> 000009022645 BOU INCENSE REG ASST 1
> 000009022652 BOU INCENSE GAR ASST 9

That did the trick. Thanks very much!

Ingolf wrote:
> Hi,
>
> with your example data in range A1:C39 use the following formula in
> column D:
>
> =SUMPRODUCT(($A$1:$A$39&$B$1:$B$39=A1&B1)*($C$1:$C$39))
>
> Regards,
> Ingolf
>
>
>
> Oggie Ben Doggie schrieb:
>
> > Hi all, you've been so helpful I had to throw this at you.
> >
> > I have a table of data (see below).
> >
> > You'll note there are multiple identical items in the 1st and 2nd
> > columns, the third being different
> >
> > Is there an easy way to "squash" and consolidate the information,
> > summing the 3rd column and place it beside the corresponding items in
> > columns 1 and 2?
> >
> >
> > The (short version of ) the info:
> >
> >
> > 016073217948 BETTY BALL EXP ENERG 11
> > 016073217948 BETTY BALL EXP ENERG 0
> > 016073217948 BETTY BALL EXP ENERG 2
> > 016073217948 BETTY BALL EXP ENERG 1
> > 016073217948 BETTY BALL EXP ENERG 23
> > 016073217948 BETTY BALL EXP ENERG 29
> > 018627175209 KASHI GOLEAN DRK VN4 2
> > 018627175209 KASHI GOLEAN DRK VN4 2
> > 000009022621 BOU OIL ROLL ON ASST 64
> > 000009022621 BOU OIL ROLL ON ASST 29
> > 000009022621 BOU OIL ROLL ON ASST 24
> > 000009022621 BOU OIL ROLL ON ASST 110
> > 000009022621 BOU OIL ROLL ON ASST 86
> > 000009022621 BOU OIL ROLL ON ASST 13
> > 000009022621 BOU OIL ROLL ON ASST 105
> > 000009022621 BOU OIL ROLL ON ASST 52
> > 000009022621 BOU OIL ROLL ON ASST 61
> > 000009022621 BOU OIL ROLL ON ASST 2
> > 000009022621 BOU OIL ROLL ON ASST 1
> > 000009022621 BOU OIL ROLL ON ASST 1
> > 000009022621 BOU OIL ROLL ON ASST 1
> > 000009022621 BOU OIL ROLL ON ASST 1
> > 000009022638 BOU OIL MINARET ASST 11
> > 000009022638 BOU OIL MINARET ASST 5
> > 000009022638 BOU OIL MINARET ASST 7
> > 000009022638 BOU OIL MINARET ASST 15
> > 000009022638 BOU OIL MINARET ASST 21
> > 000009022638 BOU OIL MINARET ASST 2
> > 000009022638 BOU OIL MINARET ASST 19
> > 000009022638 BOU OIL MINARET ASST 16
> > 000009022645 BOU INCENSE REG ASST 12
> > 000009022645 BOU INCENSE REG ASST 16
> > 000009022645 BOU INCENSE REG ASST 8
> > 000009022645 BOU INCENSE REG ASST 5
> > 000009022645 BOU INCENSE REG ASST 31
> > 000009022645 BOU INCENSE REG ASST 13
> > 000009022645 BOU INCENSE REG ASST 1
> > 000009022645 BOU INCENSE REG ASST 1
> > 000009022652 BOU INCENSE GAR ASST 9