converting a single column into multiple columns between spaces.

I have attached a file. If you look at rows below 120 the data should correspond to row 119 which shows 15 columns.
libertyforall2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

andymacfCommented:
There is no file attachment, however this can be done in excel by selecting the all the rows you wish to convert and then clicking on the 'Data' tab, select 'Text to Columns' and a wizard will open asking you to identify what you seperator is and where you wish to paste the new data.

Please attach your file if you need further assistance.

Hope this helps
Andy
libertyforall2Author Commented:
The only problem with that option is that data is not perfectly lined up so when I insert a break, it only includes some of the data. See attachment.
libertyforall2Author Commented:
Here is the attachment.
Workbook4.xls
andymacfCommented:
I have run the 'text to column' parameter on your data and attach the same here for you to have a look at.  Is this want you want to do, or can you explain further what it is you wish to do with your data?

Andy
Workbook4.xls

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
libertyforall2Author Commented:
Works thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.