https://community.qlik.com/t5/App-Development/Concat-two-colums-in-straight-table-with-repeat/m-p/2076429#M88274 <P>Hi I have a table.</P> <TABLE width="263"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="113">EMPLOYEE NAME</TD> <TD width="86">AUDIT PLACE</TD> </TR> <TR> <TD>E123</TD> <TD>PAVAN</TD> <TD>HYD</TD> </TR> <TR> <TD>E123</TD> <TD>PAVAN</TD> <TD>UI</TD> </TR> <TR> <TD>E124</TD> <TD>SAI</TD> <TD>VSP</TD> </TR> <TR> <TD>E111</TD> <TD>KUMAR</TD> <TD>HYD</TD> </TR> <TR> <TD>E124</TD> <TD>SAI</TD> <TD>HHH</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I need the following output in straight table:</P> <TABLE width="272"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="208">EMPLOYEE NAME / <BR />AUDIT PLACE</TD> </TR> <TR> <TD>E123</TD> <TD width="208">PAVAN / <BR />HYD <BR />UI</TD> </TR> <TR> <TD>E124</TD> <TD width="208">SAI / <BR />VSP<BR />HHH</TD> </TR> <TR> <TD>E111</TD> <TD width="208">KUMAR <BR />HYD</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I used&nbsp;EMPLOYEE NAME&amp;chr(10)&amp;AUDIT PLACE, but its not working.&nbsp;</P> <P>Please help me</P> Thu, 25 May 2023 15:55:43 GMT Victorysai 2023-05-25T15:55:43Z https://community.qlik.com/t5/App-Development/Concat-two-colums-in-straight-table-with-repeat/m-p/2076429#M88274 <P>Hi I have a table.</P> <TABLE width="263"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="113">EMPLOYEE NAME</TD> <TD width="86">AUDIT PLACE</TD> </TR> <TR> <TD>E123</TD> <TD>PAVAN</TD> <TD>HYD</TD> </TR> <TR> <TD>E123</TD> <TD>PAVAN</TD> <TD>UI</TD> </TR> <TR> <TD>E124</TD> <TD>SAI</TD> <TD>VSP</TD> </TR> <TR> <TD>E111</TD> <TD>KUMAR</TD> <TD>HYD</TD> </TR> <TR> <TD>E124</TD> <TD>SAI</TD> <TD>HHH</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I need the following output in straight table:</P> <TABLE width="272"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="208">EMPLOYEE NAME / <BR />AUDIT PLACE</TD> </TR> <TR> <TD>E123</TD> <TD width="208">PAVAN / <BR />HYD <BR />UI</TD> </TR> <TR> <TD>E124</TD> <TD width="208">SAI / <BR />VSP<BR />HHH</TD> </TR> <TR> <TD>E111</TD> <TD width="208">KUMAR <BR />HYD</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I used&nbsp;EMPLOYEE NAME&amp;chr(10)&amp;AUDIT PLACE, but its not working.&nbsp;</P> <P>Please help me</P> Thu, 25 May 2023 15:55:43 GMT https://community.qlik.com/t5/App-Development/Concat-two-colums-in-straight-table-with-repeat/m-p/2076429#M88274 Victorysai 2023-05-25T15:55:43Z https://community.qlik.com/t5/App-Development/Concat-two-colums-in-straight-table-with-repeat/m-p/2076478#M88276 <P>maybe like this?</P> <LI-CODE lang="markup">Concat(distinct [EMPLOYEE NAME], Chr(10))&amp;' /'&amp;Chr(10)&amp;Concat(distinct [AUDIT PLACE], Chr(10))</LI-CODE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarcoWedel_0-1685034840828.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/108385iC7241E2DE7D6BEC9/image-size/medium?v=v2&amp;px=400" role="button" title="MarcoWedel_0-1685034840828.png" alt="MarcoWedel_0-1685034840828.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 25 May 2023 17:14:56 GMT https://community.qlik.com/t5/App-Development/Concat-two-colums-in-straight-table-with-repeat/m-p/2076478#M88276 MarcoWedel 2023-05-25T17:14:56Z