Split data into multiple columns
Sometimes, data is consolidated into one column, such as first name and last name. But you might want separate columns for each. So, you can split the Sales Rep first name and last name into two columns.
-
Select the "Sales Rep" column, and then select Home > Transform > Split Column.
-
Select Choose the By Delimiter.
-
Select the default Each occurrence of the delimiter option, and then select OK. Power Query splits the Sales Rep names into two different columns named "Sales Rep 1" and "Sales Rep 2".
-
To change the default names, rename them to "Sales Rep First" and "Sales Rep Last".
-
To return the transformed data to the Excel worksheet, select Home > Close & Load.
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
