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:

https://docs.google.com/spreadsheet/ccc?key=0AgLFdRWHtdTZdGZObHdkRldkZ3RTTEI4X0E5TnBVVEE&usp=sharing

Any and all help is appreciate!  Thanks in advance!

----------------------------------------------------------------------------------------------------------------------------