Excel users frequently want to combine columns. For example to turn:
You can do this in Excel using the ‘&’ concatenate operator. And then copy this down to all the rows that are needed.
This works fine for modifying small tables. But it is tedious when you are combining lots of columns, especially on many worksheets.
However it is trivially easy to do in Easy Data Transform:
In the right pane you can now see that a new column has been added to right hand side. Select the columns you wish to combine and the Delimiter you wish to add between them (you can leave Delimiter empty).
If you want to rename the new column you can use the Rename Cols transform.
If you want to combine the columns in a different order, use the Reorder cols transform in the left pane before you Concat Cols.
When you are happy with the results output the result into a new Excel spreadsheet or CSV file.
Note that Concat cols is just one of 46 transforms that Easy Data Transform supports. It can split Excel columns just as easily.
v1.9.1 for Windows 10 / 8 / 7 (49 MB)
v1.9.1 for Mac 10.15 to 10.12 (23 MB)
Questions or problems?