new table structure

[drohm002]

Hello, please see my current table structure attached and then my desired structure:

how do i build the desired table structure?  I'm trying to turn two rows into one row in the table

[marcus_sommer · Accepted solution]

Such transformations could be done with The Generic Load - Qlik Community - 1473470. If there are only a few quite known cases such target-table might be also created with two or three joins.

Be aware that the intended target-structure (which is crosstable) has usually a lot of disadvantages against a normal record-structure. Therefore you should have good reasons for such a measurement.