Variant of transposing of a data table

[Rotterdam]

Hello,

I'm working on a new dataset, and I'm having trouble transposing data to a more usuable format.

Simplified example of source data:

ID#	TypeID	Value
100	ItemNumber	Item01
100	Description	Desc01
100	Lenght	12
100	Width	12
100	Height	12
110	ItemNumber	Item02
110	Description	Desc02
110	Lenght	16
110	Width	12
110	Height	10
120	ItemNumber	Item03
120	Description	Desc03
120	Lenght	18
120	Width	8
120	Height	12

Goal is to show as:

ID#	ItemNumber	Description	Lenght	Width	Height
100	Item01	Desc01	12	12	12
110	Item02	Desc02	16	12	10
120	Item03	Desc03	18	8	12

I've now set up a separate load of source data for every column in the result, but there must a better way I don't know of yet.

Working in Qlk Sense August 2022 Patch 13

[marcus_sommer · Accepted solution]

You may apply the The Generic Load - Qlik Community - 1473470.

[Rotterdam]

That worked, thanks!