The Split Column function allows you to slice one column into multiple new columns based on a specified delimiter string.
Access the Split Column function from the Fx menu and select the column you'd like to operate on, and the separator or delimiter. Common separators include comma, space, pipe, etc. This function supports multiple character strings as a delimiter or separator (e.g., ||).
The new columns will appear to the right of the column you've split. The original column remains intact.
See this video for more information on Splitting Columns