https://community.qlik.com/t5/QlikView/Merage-four-column-names-as-one-column/m-p/2003814#M1221474 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/200957">@AhmedElads</a> Use cross table function to get the data as you desired, please refer below link for reference</P> <P>&nbsp;</P> <P><A href="https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/LoadData/work-with-cross-tables.htm" target="_blank" rel="noopener">https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/LoadData/work-with-cross-tables.htm</A>&nbsp;</P> Sun, 13 Nov 2022 09:33:23 GMT Rockstar7 2022-11-13T09:33:23Z https://community.qlik.com/t5/QlikView/Merage-four-column-names-as-one-column/m-p/2003812#M1221473 <P>Hello,<BR />I have a table which have this column:<BR />DEP&nbsp; &nbsp;IR&nbsp; &nbsp; &nbsp;RR&nbsp; &nbsp; &nbsp;Cl&nbsp; &nbsp; &nbsp; &nbsp;EF<BR />Acc&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5<BR />Fic&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; .5&nbsp; &nbsp; 1.5&nbsp; &nbsp; &nbsp; 2&nbsp;</P> <P>and I need this expected output:</P> <P>GD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Measure_name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Values<BR />Acc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<BR />Acc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<BR />Acc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3<BR />Acc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5</P> <P>and so on with all DEP</P> <P><BR />How can i do that with qlik?</P> <P>Thanks</P> Sun, 13 Nov 2022 08:55:02 GMT https://community.qlik.com/t5/QlikView/Merage-four-column-names-as-one-column/m-p/2003812#M1221473 AhmedElads 2022-11-13T08:55:02Z https://community.qlik.com/t5/QlikView/Merage-four-column-names-as-one-column/m-p/2003814#M1221474 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/200957">@AhmedElads</a> Use cross table function to get the data as you desired, please refer below link for reference</P> <P>&nbsp;</P> <P><A href="https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/LoadData/work-with-cross-tables.htm" target="_blank" rel="noopener">https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/LoadData/work-with-cross-tables.htm</A>&nbsp;</P> Sun, 13 Nov 2022 09:33:23 GMT https://community.qlik.com/t5/QlikView/Merage-four-column-names-as-one-column/m-p/2003814#M1221474 Rockstar7 2022-11-13T09:33:23Z