Suppose I have Column A that contains a company's name and in Column B is a
stockholder in that company. However, the program that provides this
information only puts one shareholder in each cell in column B. For example:

Microsoft Bob Jones
Microsoft John Doe
Microsoft Jimmy Doogan

This goes on for over 100 rows.

I am trying to figure out a way that the information from column B can be
entered again into one cell based on if it the people are the owners of stock
of the same company. In the example above I would like Column C to have one
box that says Microsoft and Column D that says Bob Jones, John Doe, Jimmy
Doogan. Any help you can provide would be appreciated. I have little
experience with VBA so if your recommendation is to use VBA please try and
explain what each line item is telling the computer so I can try and learn
from it in the future. Thanks, Chris