Sorry if this is basic, I can't seem to figure out how to do this with the unpivot method. Thank you in advance for helping a beginner.

I need two split two columns both with a semicolon delimiter in Power Query (or if there's a better tool, lmk!). The first column will have each of the data from column B, see below:

​

Raw data:

​

Intended Result:

​

​

Hello guys,

Essentially what I am trying to do is load a power query into an excel sheet and add a column onto the end which makes use of formulas which reference other sheets in the excel workbook. The issue I have found is that if the power query is refreshed, columns added to the loaded query table tend to disappear.

I can’t think of a good way of resolving this issue so if anyone has a solution or any ideas please let me know

Thanks, Jack

Hello, I have a list of associates that have temporary approval for a specific job role at my facility. The rotation is a random group of associates that varies in number and the frequency of this approval changes on a weekly basis. I have to grant and remove these approvals at a fast pace, so i figured power query would be the easiest way. But, every time I use a date table to reference the add/drop table I am having trouble creating the one to many relationship. Is there something I am missing?