Is there a way to pull text data out of a single cell into multiple rows. i have a bunch of sub brands that i need to pull out and connect to the primary company. tried doing aright to table but it said the table was invalid; here's what tthe data looks like
