topic Reshape Table or Cross Table ? in Water Cooler https://community.qlik.com/t5/Water-Cooler/Reshape-Table-or-Cross-Table/m-p/1523287#M7739 <P>This is my input table :</P><P>for each row, i need to have 5 lines rows for 5 quarters .</P><P>quarter should be a column and it will have quarter info, Value should be another column which have corresponding values in it.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>FLOCATION</TD><TD>TSIZE</TD><TD>DNUMBER</TD><TD>MNUMBER</TD><TD>BCODE</TD><TD>1804</TD><TD>1901</TD><TD>1902</TD><TD>1903</TD><TD>1904</TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,600</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,100</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,475</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,594</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,501</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 650</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 455</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 787</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 716</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp; 1,000</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 349</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 918</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp; 1,178</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp; 1,150</FONT></TD></TR><TR><TD>MI FB S2</TD><TD>20MN</TD><TD>56745HYDAF9</TD><TD>56745HYDAF9</TD><TD>56745HYDAF9</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD></TR><TR><TD>MI FB S2</TD><TD>20MN</TD><TD>56745HYDA1A</TD><TD>56745HYDAF9</TD><TD>56745HYDAF9</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD></TR><TR><TD>TSMC FAB 12</TD><TD>30MN</TD><TD>56745HYDQ</TD><TD>56745HYDQ</TD><TD>56745HYDQ</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 75</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 274</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 249</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Need out put table like this..</P><P>This is output for only 4 rows of the above table.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>FLOCATION</TD><TD>TSIZE</TD><TD>DNUMBER</TD><TD>MNUMBER</TD><TD>BCODE</TD><TD>QTR</TD><TD>Value</TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1804</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1901</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1902</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1903</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1904</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1804</FONT></TD><TD><FONT color="#008000">1600</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1901</FONT></TD><TD><FONT color="#008000">1100</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1902</FONT></TD><TD><FONT color="#008000">1475</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1903</FONT></TD><TD><FONT color="#008000">1594</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1904</FONT></TD><TD><FONT color="#008000">1501</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1804</FONT></TD><TD><FONT color="#808000">650</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1901</FONT></TD><TD><FONT color="#808000">-</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1902</FONT></TD><TD><FONT color="#808000">455</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1903</FONT></TD><TD><FONT color="#808000">787</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1904</FONT></TD><TD><FONT color="#808000">716</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1804</FONT></TD><TD><FONT color="#666699">1000</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1901</FONT></TD><TD><FONT color="#666699">349</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1902</FONT></TD><TD><FONT color="#666699">918</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1903</FONT></TD><TD><FONT color="#666699">1178</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1904</FONT></TD><TD><FONT color="#666699">1150</FONT></TD></TR></TBODY></TABLE> Fri, 21 Dec 2018 01:02:27 GMT flames 2018-12-21T01:02:27Z Reshape Table or Cross Table ? https://community.qlik.com/t5/Water-Cooler/Reshape-Table-or-Cross-Table/m-p/1523287#M7739 <P>This is my input table :</P><P>for each row, i need to have 5 lines rows for 5 quarters .</P><P>quarter should be a column and it will have quarter info, Value should be another column which have corresponding values in it.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>FLOCATION</TD><TD>TSIZE</TD><TD>DNUMBER</TD><TD>MNUMBER</TD><TD>BCODE</TD><TD>1804</TD><TD>1901</TD><TD>1902</TD><TD>1903</TD><TD>1904</TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,600</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,100</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,475</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,594</FONT></TD><TD><FONT color="#008000">&nbsp;&nbsp; 1,501</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 650</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 455</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 787</FONT></TD><TD><FONT color="#808000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 716</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp; 1,000</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 349</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 918</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp; 1,178</FONT></TD><TD><FONT color="#666699">&nbsp;&nbsp; 1,150</FONT></TD></TR><TR><TD>MI FB S2</TD><TD>20MN</TD><TD>56745HYDAF9</TD><TD>56745HYDAF9</TD><TD>56745HYDAF9</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD></TR><TR><TD>MI FB S2</TD><TD>20MN</TD><TD>56745HYDA1A</TD><TD>56745HYDAF9</TD><TD>56745HYDAF9</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD></TR><TR><TD>TSMC FAB 12</TD><TD>30MN</TD><TD>56745HYDQ</TD><TD>56745HYDQ</TD><TD>56745HYDQ</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 75</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 274</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 249</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Need out put table like this..</P><P>This is output for only 4 rows of the above table.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>FLOCATION</TD><TD>TSIZE</TD><TD>DNUMBER</TD><TD>MNUMBER</TD><TD>BCODE</TD><TD>QTR</TD><TD>Value</TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1804</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1901</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1902</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1903</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#000080">MI FB 1</FONT></TD><TD><FONT color="#000080">10MN</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">5618A2B</FONT></TD><TD><FONT color="#000080">1904</FONT></TD><TD><FONT color="#000080">-</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1804</FONT></TD><TD><FONT color="#008000">1600</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1901</FONT></TD><TD><FONT color="#008000">1100</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1902</FONT></TD><TD><FONT color="#008000">1475</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1903</FONT></TD><TD><FONT color="#008000">1594</FONT></TD></TR><TR><TD><FONT color="#008000">MI FB 2</FONT></TD><TD><FONT color="#008000">20MN</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">56745HYDAQ3</FONT></TD><TD><FONT color="#008000">1904</FONT></TD><TD><FONT color="#008000">1501</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1804</FONT></TD><TD><FONT color="#808000">650</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1901</FONT></TD><TD><FONT color="#808000">-</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1902</FONT></TD><TD><FONT color="#808000">455</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1903</FONT></TD><TD><FONT color="#808000">787</FONT></TD></TR><TR><TD><FONT color="#808000">MI FB 2</FONT></TD><TD><FONT color="#808000">20MN</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">56745HYDAP4</FONT></TD><TD><FONT color="#808000">1904</FONT></TD><TD><FONT color="#808000">716</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1804</FONT></TD><TD><FONT color="#666699">1000</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1901</FONT></TD><TD><FONT color="#666699">349</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1902</FONT></TD><TD><FONT color="#666699">918</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1903</FONT></TD><TD><FONT color="#666699">1178</FONT></TD></TR><TR><TD><FONT color="#666699">MI FB 2</FONT></TD><TD><FONT color="#666699">20MN</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">56745HYDAE4</FONT></TD><TD><FONT color="#666699">1904</FONT></TD><TD><FONT color="#666699">1150</FONT></TD></TR></TBODY></TABLE> Fri, 21 Dec 2018 01:02:27 GMT https://community.qlik.com/t5/Water-Cooler/Reshape-Table-or-Cross-Table/m-p/1523287#M7739 flames 2018-12-21T01:02:27Z Re: Reshape Table or Cross Table ? https://community.qlik.com/t5/Water-Cooler/Reshape-Table-or-Cross-Table/m-p/1523288#M7740 What do you by reshape table?<BR />Did you try cross table load? This looks ideal<BR />E.g.<BR />Crosstable (QTR,Value,5)<BR />Load<BR />*.... Fri, 21 Dec 2018 02:44:55 GMT https://community.qlik.com/t5/Water-Cooler/Reshape-Table-or-Cross-Table/m-p/1523288#M7740 dplr-rn 2018-12-21T02:44:55Z Re: Reshape Table or Cross Table ? https://community.qlik.com/t5/Water-Cooler/Reshape-Table-or-Cross-Table/m-p/1523307#M7741 <P>yeah, Thanks, it worked.&nbsp;</P><P>I remember&nbsp; 'reshape' command in R, so asked a similar kind here, your solution worked anyway, Thanks again.</P> Fri, 21 Dec 2018 05:56:46 GMT https://community.qlik.com/t5/Water-Cooler/Reshape-Table-or-Cross-Table/m-p/1523307#M7741 flames 2018-12-21T05:56:46Z