data in one column into several columns with certain rules

Hey Guys-
I've looked around the forum and couldn't quite piece together what I need for this problem I'm having. I have minimal understanding of macros - probably a 2 week portion of a tech class I took years ago.

I have data that is all within column A, but I need it to be separated into 14 separate columns.

The data looks like this:
*note xx's denote numbers

11 - Product ID1
----------------------------
1234567 AA A xxxx-x0 String1 String2(Company Name) String3 xxxxx1 01/11/11 01/11/13 02/13/12 xxxx2 03/13/13 xxxx3

12 - Product ID2
----------------------------
etc..

As you can see the data is actually spaced out nicely, however, the strings may have extra spaces and that throws off the text-to-columns function.

-Not all columns will have values
-the string values may have one word or multiple words(with spaces and/or -)
-The Product ID titles along w/ the dotted lines should be skipped (remain the same)

Please help - information would be greatly appreciated to ease the headaches of my job. THANKS!