Excel users frequently want to split one or more columns. For example to turn:
Into:
You can do this in Excel using the Date>Text To Columns function. But it is fairly onerous and you lose the data that was there before.
However it is very easy to split columns in Easy Data Transform:
In the right pane set Column to the column you wish to split and Delimiter to the character you want to use to split the column (e.g. a space character).
You can now see that new name columns have been added to right hand side of the table.
If you want to rename the new columns, you can use the Rename Cols transform.
When you are happy with the results output the result into a new Excel spreadsheet or CSV file.
Easy Data Transform allows you to combine multiple transforms, such as Split Col, to quickly and easily create complex data transformations. It can combine Excel columns just as easily.
v1.13.1 for Windows 10 / 8 / 7 (30 MB)
v1.13.1 for Mac 11.1 to 10.13 (31 MB)
Questions or problems?
Do you have a question?
We would love to help.
This pop-up will not be shown again