This Analytics Edge wizard lets you split a text column into several columns. You can split on a delimiter, a fixed-width sequence, or into smart name columns.
It can be used to split name fields apart (the smart name option), or to split product codes or URLs.
Split Into Columns
Splits the selected column into multiple columns, named with suffix -1, -2, etc.
Remove original column – to remove the column that has been split, check this option.
Split into Rows
Splits multiple values in the selected column into multiple rows.
Ignore duplicates – if the column contains multiple but identical values, ignore the duplicates and create only one row for each unique value.
Select a column by position (column letter) or By Name to be split.
Choose how the column will be split.
Delimiter – select a delimiter that separates the values in the column. Optionally enter your own sequence of characters (may be more than one).
Smart name – select this option to split a column into various name parts.