https://community.qlik.com/t5/App-Development/Transpose-data-in-a-table/m-p/1867976#M71674 <P>I have a table that looks like this:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="33.333333333333336%">StorageID</TD> <TD width="33.333333333333336%">Question</TD> <TD width="33.333333333333336%">Answer</TD> </TR> <TR> <TD width="33.333333333333336%">1</TD> <TD width="33.333333333333336%">A</TD> <TD width="33.333333333333336%">1A</TD> </TR> <TR> <TD width="33.333333333333336%">1</TD> <TD width="33.333333333333336%">B</TD> <TD width="33.333333333333336%">1B</TD> </TR> <TR> <TD width="33.333333333333336%">1</TD> <TD width="33.333333333333336%">C</TD> <TD width="33.333333333333336%">1C</TD> </TR> <TR> <TD>2</TD> <TD>A</TD> <TD>2A</TD> </TR> <TR> <TD>2</TD> <TD>D</TD> <TD>2D</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to transpose this data so that the table would look like this:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%">StorageID</TD> <TD width="25%">A</TD> <TD width="25%">B</TD> <TD width="12.5%">C</TD> <TD width="12.5%">D</TD> </TR> <TR> <TD width="25%">1</TD> <TD width="25%">1A</TD> <TD width="25%">1B</TD> <TD width="12.5%">1C</TD> <TD width="12.5%">&nbsp;</TD> </TR> <TR> <TD width="25%">2</TD> <TD width="25%">2A</TD> <TD width="25%">&nbsp;</TD> <TD width="12.5%">&nbsp;</TD> <TD width="12.5%">2D</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Is this possible and so yes, how would i do this?</P> <P>Thanks in advance!</P> Wed, 08 Dec 2021 09:15:25 GMT sgrobben 2021-12-08T09:15:25Z https://community.qlik.com/t5/App-Development/Transpose-data-in-a-table/m-p/1867976#M71674 <P>I have a table that looks like this:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="33.333333333333336%">StorageID</TD> <TD width="33.333333333333336%">Question</TD> <TD width="33.333333333333336%">Answer</TD> </TR> <TR> <TD width="33.333333333333336%">1</TD> <TD width="33.333333333333336%">A</TD> <TD width="33.333333333333336%">1A</TD> </TR> <TR> <TD width="33.333333333333336%">1</TD> <TD width="33.333333333333336%">B</TD> <TD width="33.333333333333336%">1B</TD> </TR> <TR> <TD width="33.333333333333336%">1</TD> <TD width="33.333333333333336%">C</TD> <TD width="33.333333333333336%">1C</TD> </TR> <TR> <TD>2</TD> <TD>A</TD> <TD>2A</TD> </TR> <TR> <TD>2</TD> <TD>D</TD> <TD>2D</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to transpose this data so that the table would look like this:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="25%">StorageID</TD> <TD width="25%">A</TD> <TD width="25%">B</TD> <TD width="12.5%">C</TD> <TD width="12.5%">D</TD> </TR> <TR> <TD width="25%">1</TD> <TD width="25%">1A</TD> <TD width="25%">1B</TD> <TD width="12.5%">1C</TD> <TD width="12.5%">&nbsp;</TD> </TR> <TR> <TD width="25%">2</TD> <TD width="25%">2A</TD> <TD width="25%">&nbsp;</TD> <TD width="12.5%">&nbsp;</TD> <TD width="12.5%">2D</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Is this possible and so yes, how would i do this?</P> <P>Thanks in advance!</P> Wed, 08 Dec 2021 09:15:25 GMT https://community.qlik.com/t5/App-Development/Transpose-data-in-a-table/m-p/1867976#M71674 sgrobben 2021-12-08T09:15:25Z https://community.qlik.com/t5/App-Development/Transpose-data-in-a-table/m-p/1867992#M71676 <P>u can use Generic load</P> Wed, 08 Dec 2021 09:45:04 GMT https://community.qlik.com/t5/App-Development/Transpose-data-in-a-table/m-p/1867992#M71676 anat 2021-12-08T09:45:04Z