https://community.qlik.com/t5/QlikView/Transpose-Table/m-p/1555599#M743687 <P>Hello,</P><P>I have the following table:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>VALUE</TD><TD>DESCRIPTION</TD><TD>AMOUNT</TD></TR><TR><TD>1</TD><TD>AA</TD><TD>LOCAL</TD><TD>150</TD></TR><TR><TD>1</TD><TD>AA</TD><TD>INTERNATIONAL</TD><TD>100</TD></TR><TR><TD>1</TD><TD>AA</TD><TD>UNITS</TD><TD>12</TD></TR></TBODY></TABLE><P><SPAN><BR />I need to transpose the table by script in order to have the following:</SPAN></P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>VALUE</TD><TD>DESCRIPTION</TD><TD>LOCAL</TD><TD>INTERN</TD><TD>WEIGHT</TD></TR><TR><TD>1</TD><TD>AA</TD><TD>LOCAL</TD><TD>150</TD><TD>100</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is there any way to do that?</P><P>Thank you!!!</P> Wed, 25 Nov 2020 16:16:04 GMT microwin88x 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Transpose-Table/m-p/1555599#M743687 <P>Hello,</P><P>I have the following table:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>VALUE</TD><TD>DESCRIPTION</TD><TD>AMOUNT</TD></TR><TR><TD>1</TD><TD>AA</TD><TD>LOCAL</TD><TD>150</TD></TR><TR><TD>1</TD><TD>AA</TD><TD>INTERNATIONAL</TD><TD>100</TD></TR><TR><TD>1</TD><TD>AA</TD><TD>UNITS</TD><TD>12</TD></TR></TBODY></TABLE><P><SPAN><BR />I need to transpose the table by script in order to have the following:</SPAN></P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>VALUE</TD><TD>DESCRIPTION</TD><TD>LOCAL</TD><TD>INTERN</TD><TD>WEIGHT</TD></TR><TR><TD>1</TD><TD>AA</TD><TD>LOCAL</TD><TD>150</TD><TD>100</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is there any way to do that?</P><P>Thank you!!!</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Transpose-Table/m-p/1555599#M743687 microwin88x 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Transpose-Table/m-p/1555606#M743688 <P>Check out the <A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Generic.htm" target="_self">Generic Load</A></P> Tue, 12 Mar 2019 18:44:50 GMT https://community.qlik.com/t5/QlikView/Transpose-Table/m-p/1555606#M743688 jwjackso 2019-03-12T18:44:50Z https://community.qlik.com/t5/QlikView/Transpose-Table/m-p/1555770#M743689 <P>You can just add the columns into the pivot table and then Drag the Description column up to transpose the values.</P> Wed, 13 Mar 2019 06:41:23 GMT https://community.qlik.com/t5/QlikView/Transpose-Table/m-p/1555770#M743689 siddheshmane 2019-03-13T06:41:23Z