Need help with power query unpivoting.

[proficient]

Hello all,

Please check out the below screenshot of the normal table (there is an unnecessary break in each machine table) that I am getting from my colleague "DATA" along with the "DESIRED RESULT" that I want as the final result.

The data is in a regular excel table form and it would be time-taking to make official tables of each machine (a total of 16 machines) every time. I am looking forward to a code that will work if I convert the complete data into one sheet to save time by not making each machine an official excel table every time, Could anyone provide a code?

 

[proficient]

How do the data make it into the table? Does your colleague by any chance collect it from different files? That would be a good time to import from folder.The

I am getting the all machines' detail in one single sheet that was prepared manually.

I can share the original file if you want.

 

[lrobbo314]

I am not able to upload files on this computer. Select the data as it is below, i.e. M4:W13. Add the table to Power Query. Make sure that you uncheck the option saying that the table has headers. Then the code should work.

PROFICIENT
	M	N	O	P	Q	R	S	T	U	V	W
4	MACHINE 1				MACHINE 2				MACHINE 3
5	DATE	ARTICLE	OUTPUT		DATE	ARTICLE	OUTPUT		DATE	ARTICLE	OUTPUT
6	44835	ABC	300		44835	BCD	300		44835	EFG	300
7	44836	ABC	500		44836	BCD	500		44836	EFG	500
8	44837	ABC	500		44837	BCD	500		44837	EFG	500
9
10	DATE	ARTICLE	OUTPUT		DATE	ARTICLE	OUTPUT		DATE	ARTICLE	OUTPUT
11	44838	HIG	500		44838	KLM	500		44838	PQR	150
12	44839	PLK	250		44839	KLM	500		44839	PQR	250
13	44840	PLK	350		44840	KLM	500		44840	PQR	500
Sheet4

Cell Formulas
Range	Formula
M7:M8,U12:U13,Q12:Q13,M12:M13,U7:U8,Q7:Q8	M7	=M6+1