I have a sheet of roughly 2,000 investors. I am trying to keep track of each of their investments. Some of them invest indivisually, some invest through a specific account.
For example, John Smith has invested through three different accounts that appear as follows:
Column A Column B...