I would like to create a summary grid based on multiple rows of data
below

I want the summary grid to update automatically - I will then use
SUMIF to total

the data looks like this:

Col A Col B
Rob 1
Steve 1
Rob 1
Rob 1
Jared 2
Steve 5

is there any way I can dynamically create the summary grid in the
event of adding a new 'name' to the data

i.e.

Col A Col B
Rob 1
Steve 1
Rob 1
Rob 1
Jared 2
Steve 5
Jesse 1


any help appreciated


thanks
Rob