Turn strings within rows into columns with data from another column (pivot?)

[maxs3]

Hello,

I cannot figure out how to perform the below operation, I believe it is either pivot, or group, but cannot seem to find it.

Inital table:

Lot	Part	Measurement	Value
1	1	A	54
1	1	B	65
1	2	A	74
1	2	C	54
2	1	A	31
2	1	B	15
2	3	A	45
2	3	D	34

Final Desired table:

Lot	Part	A	B	C	D
1	1	54	65
1	2	74		54
2	1	31	15
2	3	45			34

[jsaunders_zero9 · Accepted solution]

To do this in Power Query select columns "Measurement" and "Value", go to transform toolbar and select pivot columns.

End state