Dividing columns
You can split a single column of data into separate columns. Right-click the column header and select from these options:
- Split Column by Delimiter
- Split Column by Fixed Width
The data is split into multiple columns. The column headers are based on the values you specify for delimiter or width. The Preview box updates when values are specified so you can see the results of the selection.
This capability is only available when loading files.