cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

1 REPLY 1

Re: Automating Amendments to my Data Model

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 DelimiterCapture.PNG

 

 

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