So I have a spreadsheet which categorises products and outputs this into a cell:
The Problem is we need to sperate this into their own columns:
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 /