Thanks for posting your question here.
You are correct that you would not need use an aggregate function. However, what you seek to accomplish has some caveats. The data set you propose shows no limit to the number of companies a Original Company / Person Name may be a part of. If, one may be a board member of 21 companies, your result set would need to have the 21 additional columns to summarize said memberships. Accomplishing this with a single query may be possible but will be terribly inefficient and error. It's also not a recommended practice with SQL to turn rows into columns which is essentially what is requested with the 'Member of Board' data set column.
If this must be accomplished, you may be able to accomplish this with using
cursors to iterate through your data set and upsert to your resulting table. Unfortunately, data relationships like these are often better represented by data systems like BigQuery which allows
repeated records or Datastore which has
repeated properties.
I hope this helps.