importing data that is merged into one column
Posted: Mon Jan 18, 2021 6:12 am
Could be an elementary question, but I was provided with data that was in the form of one column and can't figure out how to import it.
In the excel files tags like "age, employement, education, retirement, insurance" are merged, so a cell could look like "30,1,1,0,1".
Any solution would be appreciated :)
In the excel files tags like "age, employement, education, retirement, insurance" are merged, so a cell could look like "30,1,1,0,1".
Any solution would be appreciated :)