How can I extract specific information from the cells?

Question

How can I extract just the: Brand, Showroom Only Product, etc.

Answer 1

You can use REGEXEXTRACT where you can extract all characters between two known variables. The first variable can be Brand: and the second could be a line break - \n. This would translate into a formula like:

=REGEXEXTRACT(C3, "Brand: (.*)\nShowroom")

Then you could wrap it into ArrayFormula as suggested here: https://webapps.stackexchange.com/a/132303/186471