So I have a base with 2 tables - one containing the funding round details (FRD) which includes name of Startup, amount and investor
And another table solely for investors - which I wish to import data from Investors column in FRD table.
Now, the investor in FRD is input as a long text which is comma separated.
I wanted the Investor table to automatically import this data from investor column - and import it into separate rows - with startup name on the side.
I know something like linked record exists, but even there I have to manually select the investor - whereas I simply copy and paste data from the net, thats why I want the investor column data to automatically be imported in the other table.
How can I make it happen? Sharing link for sample base for your reference, please guide.