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.
Microsoft OfficePerlScripting Languages
Last Comment
libertyforall2
8/22/2022 - Mon
Andrew
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
libertyforall2
ASKER
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.
Please attach your file if you need further assistance.
Hope this helps
Andy