Need help splitting keywords in cell into rows

[linister]

Hi,
Can someone please help achieve the same result as the one shown in the expected output format:

KWT

Sheet1 Prompt List Current Input,What can I add to this current formula to make each line seperate into a new row,Wanted Output,Keywords,As an SEO expert, please provide 5 keywords that are frequently searched for and are related to the URL provided. Don't add any line numbers before the keywor...

docs.google.com

What can i add to the formula in C5 to make that happen?

Thanks alot,
Lin

 

[zero269]

Hi,
Can someone please help achieve the same result as the one shown in the expected output format:

KWT

Sheet1 Prompt List Current Input,What can I add to this current formula to make each line seperate into a new row,Wanted Output,Keywords,As an SEO expert, please provide 5 keywords that are frequently searched for and are related to the URL provided. Don't add any line numbers before the keywor...

docs.google.com

What can i add to the formula in C5 to make that happen?

Thanks alot,
Lin

I don't use Google Docs, but they do have a SplitText Function that can split that single cell into multiple rows using a delimiter.

SPLIT function - Google Docs Editors Help

Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Examples Make a copy

support.google.com

Unfortunately, your cell doesn't have an obvious delimiter.
Surprisingly each line ends with Furniture, so I used Find & Replace to add a comma after each instance of Furniture and then used the comma as a delimiter to separate those values into 5 Rows.
If you can find out how to use the return line as a delimiter, that might be an option... but don't quote me on it.

 

[linister]

I don't use Google Docs, but they do have a SplitText Function that can split that single cell into multiple rows using a delimiter.

SPLIT function - Google Docs Editors Help

Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Examples Make a copy

support.google.com

Unfortunately, your cell doesn't have an obvious delimiter.
Surprisingly each line ends with Furniture, so I used Find & Replace to add a comma after each instance of Furniture and then used the comma as a delimiter to separate those values into 5 Rows.
If you can find out how to use the return line as a delimiter, that might be an option... but don't quote me on it.

Thanks zero269 but unfortunately this wouldn't work as not always the keyword will include Furniture, I am able to transpose each keyword by line break but i want as well new row to be added for each keyword which i don't know how to do.