Automating Amendments to my Data Model

[johnbradbury]

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

[SteveCampbell]

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 /