Try to use Crosstable function (https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/LoadData/work-with-cross-tables.htm).
Or you can use this example Multiple rows with different dimensions
Hope this will help)
Didn't notice that you are referring to Qlik Sense, but the load script has no different with Qlik View.
Refer attached is the file in qvf (Qlik Sense).
Thanks and regards,
GenericTable.qvf 176.0 K
You can use the Concat() string concatenation aggregation function along with GROUP BY:
Final: LOAD Name, Concat( If( Class = 'English' , Teacher ) ) AS English, Concat( If( Class = 'French' , Teacher ) ) AS French, Concat( If( Class = 'German' , Teacher) ) AS German RESIDENT School GROUP BY Name;
Actually MinString(), MaxString() and Only() should work just as well as Concat().