Unstack dataset

[GreenCat223]

Hi there,

I was wondering if you help me transform the following dataset?

This is how it comes out of the system:

EmpNum	ProductName	InputName	EntryValue	Product Entry ID
Emp1	Apples	Type	GrannySmith	123​
Emp1	Apples	Units	5​	123​
Emp1	Apples	Type	Gala	456​
Emp1	Apples	Units	3​	456​
Emp1	Apples	Type	Braeburn	789​
Emp1	Apples	Units	1​	789​
Emp1	Apples	Type	PinkLady	321​
Emp1	Apples	Units	7​	321​

This is how I want it to look like:

EmpNum	ProductName	Type	Units	Product Entry ID
Emp1	Apples	GrannySmith	5​	123​
Emp1	Apples	Gala	3​	456​
Emp1	Apples	Braeburn	1​	789​
Emp1	Apples	PinkLady	7​	321​

All solutions are welcome!

Please explain your thought process with solving this as I can seem to crack this using Power Query!

Many thanks!

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    cols = {"Type", "Units"},
    tblGroup = Table.Group(Source, {"EmpNum", "ProductName", "Product Entry ID"}, {{"rcd", each Record.FromList([EntryValue],cols)}}),
    tblExpand = Table.ExpandRecordColumn(tblGroup, "rcd", cols)
in
    tblExpand

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Table2						Query Output
2	EmpNum	ProductName	InputName	EntryValue	Product Entry ID		EmpNum	ProductName	Product Entry ID	Type	Units
3	Emp1	Apples	Type	GrannySmith	123		Emp1	Apples	123	GrannySmith	5
4	Emp1	Apples	Units	5	123		Emp1	Apples	456	Gala	3
5	Emp1	Apples	Type	Gala	456		Emp1	Apples	789	Braeburn	1
6	Emp1	Apples	Units	3	456		Emp1	Apples	321	PinkLady	7
7	Emp1	Apples	Type	Braeburn	789
8	Emp1	Apples	Units	1	789
9	Emp1	Apples	Type	PinkLady	321
10	Emp1	Apples	Units	7	321
11
Sheet2

 

[GreenCat223]

Thank you soooo much!!