https://community.qlik.com/t5/App-Development/new-table-structure/m-p/2546291#M109925 <P>Hello, please see my current table structure attached and then my desired structure:</P><P>how do i build the desired table structure?&nbsp; I'm trying to turn two rows into one row in the table</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp; &nbsp;&nbsp;</P><P>&nbsp; &nbsp; &nbsp;</P><P>&nbsp;</P><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV><P>&nbsp;</P> Tue, 07 Apr 2026 14:53:38 GMT drohm002 2026-04-07T14:53:38Z https://community.qlik.com/t5/App-Development/new-table-structure/m-p/2546291#M109925 <P>Hello, please see my current table structure attached and then my desired structure:</P><P>how do i build the desired table structure?&nbsp; I'm trying to turn two rows into one row in the table</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp; &nbsp;&nbsp;</P><P>&nbsp; &nbsp; &nbsp;</P><P>&nbsp;</P><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV><P>&nbsp;</P> Tue, 07 Apr 2026 14:53:38 GMT https://community.qlik.com/t5/App-Development/new-table-structure/m-p/2546291#M109925 drohm002 2026-04-07T14:53:38Z https://community.qlik.com/t5/App-Development/new-table-structure/m-p/2546301#M109926 <P>Such transformations could be done with <A href="https://community.qlik.com/t5/Design/The-Generic-Load/ba-p/1473470" target="_blank">The Generic Load - Qlik Community - 1473470</A>. If there are only a few quite known cases such target-table might be also created with two or three joins.</P><P>Be aware that the intended target-structure (which is crosstable) has usually a lot of disadvantages against a normal record-structure. Therefore you should have good reasons for such a measurement.</P> Tue, 07 Apr 2026 15:21:56 GMT https://community.qlik.com/t5/App-Development/new-table-structure/m-p/2546301#M109926 marcus_sommer 2026-04-07T15:21:56Z