How do I compress table to aggregate values for unique names?

[MikeMcCollister]

I have a "Regular Table" with names and numbers associated with them. I want to compress that table into the alphabetized unique names with the aggregate values for each name. I can use

=SORT(UNIQUE(Table1[Name]))

to get the sorted array for unique names. However, I don't know how to get the aggregate values for each name so that it creates an array that will grow if my original table grows. Any idea how to do that?

In the screen capture above, I put the formula that I am using in B15 as text in C15 for reference. B16 to B20 use similar formulas.

Thanks,

Mike

 

[Fluff]

How about

=GROUPBY(Table1{Name],Table1[Number],0,0)

 

[MikeMcCollister]

How about

=GROUPBY(Table1{Name],Table1[Number],0,0)

Thanks. That is exactly what I needed. I did have to make a minor revision, as follows:

=GROUPBY(Table1[Name], Table1[Number], SUM, 0, 0)

With the sort, it is this:

=SORT(GROUPBY(Table1[Name], Table1[Number], SUM, 0, 0))

 

[Fluff]

There is no need to use sort, as groupby will automatically sort based on the 1st column.

 

[MikeMcCollister]

Thanks! I did not notice that the sort was automatic. Sweet.

 

[MikeMcCollister]

Now if Excel would just let us format arrays as tables, I would have a very nice day.

 

[Fluff]

Glad to help & thanks for the feedback.