Need help moving multiple lines of data in single cell to unique subsequent rows

Hi there! My name is Brett. This is my first time posting in this forum.

I have an issue where I have a rows of data with six columns. One of the columns has multiple lines of data in a single cell. I need to turn each line into its own unique row while preserving the other columns to remain in the first row. Here is an example of what my "as-is" worksheet looks like:

Capture.JPG


This is what my "to-be" worksheet needs to look like:

Capture2.JPG

I need to do this for ~12,000 rows in my worksheet. I am not good with marcos and am assuming that's what I'll need to use to accomplish this task. Any help would be greatly appreciated. I'll attach the Workbook (document 5) with two tabs (As-Is and To-Be).

Also, I am using Excel 2007