Saturday, July 27, 2013

yogi_Split Row on New Line For All Entries In Column A Down From Row 2

                                          Google Spreadsheet   Post  #1309
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 27, 2013
user  Justin Duffy (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/puzvclXEGlI)
Split rows based on new line
Hi all,
I have a spreadsheet that is importing a lot of data into rows.   I need to split these rows every time there is a new line character, creating an output like the one below:

Input
Output

This is the first item.
This is the second one
Sometimes the items end in a period.
Sometimes they don't
This is the first item.

This is item 5
This is item 6
etc.
This is the second one
Item 7...
Sometimes the items end in a period.
Sometimes they don't
This is item 5
This is item 6
etc.
Item 7...

Can you do this with the SPLIT function, or do you need to write a script?  Either way I am striking out, and would appreciate any help I can get.  A sample spreadsheet is here:


Any and all help is appreciate!  Thanks in advance!
----------------------------------------------------------------------------------------------------------------------------