Add custom rows and columns in Power Query

[Shao85]

Hi, could you please anybody help me with following stuff? Trying to figure out how to add automatically rows into table which is loaded from a database source. I would like to analyze each "Status" type duration per shifts. This basically means I need to add rows per each day which will contain in "t_st column" following information:

dd.mm.yyyy 6:00 (beginning of the MorningShift)
dd.mm.yyyy 14:00 (beginning of the AfternoonShift)
dd.mm.yyyy 22:00 (beginning of the NightShift)
In each of these added rows should be coppied information about "Status" from the above row.

In next step should be added column with calculated duration of each "Status".

Below is visible data example.
example.png

Thanks in advance for any help.

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Shao85]

Here is the requested example.

[Shao85]

Nobody? Any Idea?

Here is macro which tried to make friend of mine. It is just for step one and not useful in Power Query:

Please Login or Register  to view this content.