Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Automating Amendments to my Data Model

So I have a spreadsheet which categorises products and outputs this into a cell:

 

Desktop/Laptop/HP/Model131

 

The Problem is we need to sperate this into their own columns:

 

Tier 1:

 

Desktop

 

Tier 2:

Laptop

Need Help

1 Reply

  • SteveCampbell's avatar
    SteveCampbell
    Memorable Member
    7 years ago

    I'm a little unsure of what exactly you are asking, but I think you want split by delimiter.

     

    Open the power query editor, and go to your query.

    Select the column, then on ther home tab navigate to Split Column > By Delimiter

     

     

    For "Select or enter delimiter" choose "--Custom--" on the dropdown menu, then type /