Making the elements in multiple select the row headers for another table?

[Chen_Shaojie]

Currently, my sheet is structured like this: There is a row with a company’s name, then a corresponding multiselect row with investors X, Y, Z.
Is there any way to bring up another table with X, Y, Z as row headers in the first column and the corresponding company in the next column?
Thanks!

[ScottWorld]

Instead of using a multiple select field, you‘ll want to change that field to a linked record field which links to your Investors table.