Sunday, June 19, 2022

Split data into multiple columns [MS]

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

  1. Select the "Sales Rep" column, and then select Home > Transform > Split Column.

  2. Select Choose the By Delimiter.

  3. 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".

  4. To change the default names, rename them to "Sales Rep First" and "Sales Rep Last".

  5. To return the transformed data to the Excel worksheet, select Home > Close & Load.

No comments:

Post a Comment

Search This Blog

TYPE function [MS]

TYPE function Excel for Microsoft 365 Excel for Microsoft 365 for Mac ...