Merage four column names as one column

[AhmedElads]

Hello,
I have a table which have this column:
DEP   IR     RR     Cl       EF
Acc     2       1       3         5
Fic       3      .5    1.5      2 

and I need this expected output:

GD           Measure_name          Values
Acc                        IR                               2
Acc                        RR                             1
Acc                        CI                               3
Acc                        EF                              5

and so on with all DEP

How can i do that with qlik?

Thanks

[Rockstar7 · Accepted solution]

@AhmedElads Use cross table function to get the data as you desired, please refer below link for reference

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/LoadData/work-wit...