Solved

converting a single column into multiple columns between spaces.

Posted on 2012-03-15
5
264 Views
Last Modified: 2012-03-29
I have attached a file. If you look at rows below 120 the data should correspond to row 119 which shows 15 columns.
0
Comment
Question by:libertyforall2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:andymacf
ID: 37728301
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
0
 

Author Comment

by:libertyforall2
ID: 37731011
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.
0
 

Author Comment

by:libertyforall2
ID: 37731017
Here is the attachment.
Workbook4.xls
0
 
LVL 7

Accepted Solution

by:
andymacf earned 500 total points
ID: 37731257
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
0
 

Author Closing Comment

by:libertyforall2
ID: 37785268
Works thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question