OK, there must be a way to do this. I have a list of names in column A, each
name has a number after it in column B - I want to combine all the names into
cells based on the number after the name. Exmple:

I want this (imagine that it's two columns)
bob 1
david 1
ted 2
mike 2
linda 3
anne 3

to turn into this:

bob, david 1
ted, mike 2
linda, anne 3

I can do it, but it's about a dozen steps. Is there an easier way?