Table from wide to long

[BTLR]

Hi everyone, I have a file with a teacher and different groups of students that has a wide format. I would like to convert this to a long format. So I have: 

Teacher, Student 1, Student 2, Student 3, Student 4, Student 5

Teacher, Student (1)

Teacher, Student (2)

...

Teacher, Student (5)

The order of students is irrelevant. How can I convert this table in the load editor? 

In SQL, I can use CROSS APPLY. This does not seem to work in QlikSense.

Thank you in advance. 

[Vishal_Gupta · Accepted solution]

Hi @BTLR ,

Just like SQL Cross Apply Qlik also has Cross Table functionality.

Please refer to this Documentation

Crosstable ‒ Qlik Sense on Windows