• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

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.
0
libertyforall2
Asked:
libertyforall2
  • 3
  • 2
1 Solution
 
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
0
 
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.
0
 
libertyforall2Author Commented:
Here is the attachment.
Workbook4.xls
0
 
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
0
 
libertyforall2Author Commented:
Works thanks.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now