All data in 1 column. How to separate?

The data acquisition of a machine I’m am working with puts all data into a csv file. Most of the time it is separated into the relevant headings but some of the tests have the headings correct but all the columns are combined into the first. Across thousands of rows this is time consuming to separate manually. Is there any way to separate the numbers in column 1, to other columns by the number of figures, or another way I can solve my problem?
By: Iain Atkinson

One thought on “All data in 1 column. How to separate?

Leave a Reply

Your email address will not be published. Required fields are marked *