Pivot Excel Need help

[Jeev125]

Hi All can extract my below file using power query form this 

Input Data Below

Date & TimeLocationSystemEquipmentTypeStatusStatus Type

31/03/2020 23:42	BLV	ESC	ESC-01	Escalator	Moving Status	Stopped
31/03/2020 23:42	BLV	ESC	ESC-01	Escalator	Moving Status	Moving
31/03/2020 23:26	BLV	ESC	ESC-01	Escalator	Moving Status	Stopped
31/03/2020 23:25	BLV	ESC	ESC-01	Escalator	Moving Status	Moving
31/03/2020 23:09	BLV	ESC	ESC-01	Escalator	Moving Status	Stopped
31/03/2020 23:09	BLV	ESC	ESC-01	Escalator	Moving Status	Moving

to this.

Output Data Below

Stopped	Alarm	Moving
31/03/2020 0:42	1/04/2020 11:42	31/03/2020 23:42

I tried using Pivot function in power query but couldn't shape into the above output.

[#2]

@Jeev125 

Logic is not clear, concrete data in Output of your sample have nothing common with Input. However, you may Group By status without aggregation, keep only lists with time in output and after that create Table.FromColumns using above lists as columns. Please check in atached.