Solved

converting a single column into multiple columns between spaces.

Posted on 2012-03-15
5
252 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
  • 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Outlook Free & Paid Tools
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

786 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