https://community.qlik.com/t5/QlikView/Help-Needed/m-p/1586108#M443227 <P>Hi!</P><P>usethis:</P><P>Data:<BR />LOAD * INLINE [<BR />ID, Article Name<BR />1, WW<BR />1, QE<BR />2, SS<BR />3, QZ<BR />3, QC<BR />3, QN<BR />4, QE<BR />5, KK<BR />6, JH<BR />6, LM<BR />6, TT<BR />6, PP<BR />];</P><P>Data_new:<BR />NoConcatenate<BR />load<BR />ID,<BR />Concat("Article Name",'/',) as "Article Name"<BR />resident Data<BR />group by ID;</P><P>drop table Data;</P> Wed, 29 May 2019 11:37:02 GMT martinpohl 2019-05-29T11:37:02Z https://community.qlik.com/t5/QlikView/Help-Needed/m-p/1586106#M443226 <P><STRONG>Hi All ,&nbsp;</STRONG></P><P><STRONG>i have below data set flowing&nbsp;&nbsp;( Both columns in same Table )</STRONG></P><TABLE><TBODY><TR><TD>ID</TD><TD>Article Name</TD></TR><TR><TD>1</TD><TD>WW</TD></TR><TR><TD>1</TD><TD>QE</TD></TR><TR><TD>2</TD><TD>SS</TD></TR><TR><TD>3</TD><TD>QZ</TD></TR><TR><TD>3</TD><TD>QC</TD></TR><TR><TD>3</TD><TD>QN</TD></TR><TR><TD>4</TD><TD>QE</TD></TR><TR><TD>5</TD><TD>KK</TD></TR><TR><TD>6</TD><TD>JH</TD></TR><TR><TD>6</TD><TD>LM</TD></TR><TR><TD>6</TD><TD>TT</TD></TR><TR><TD>6</TD><TD>PP</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>and i need to achieve as below in front end or Back end how to be done.</P><TABLE><TBODY><TR><TD>ID</TD><TD>Article Name</TD></TR><TR><TD>1</TD><TD>WW/QE</TD></TR><TR><TD>2</TD><TD>SS</TD></TR><TR><TD>3</TD><TD>QZ/QC/QN</TD></TR><TR><TD>4</TD><TD>QE</TD></TR><TR><TD>5</TD><TD>KK</TD></TR><TR><TD>6</TD><TD>JH/LM/TT/PP</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Pleaes help</P><P>Advance Thank:)&nbsp;</P> Wed, 29 May 2019 11:32:48 GMT https://community.qlik.com/t5/QlikView/Help-Needed/m-p/1586106#M443226 kiranpatil123 2019-05-29T11:32:48Z https://community.qlik.com/t5/QlikView/Help-Needed/m-p/1586108#M443227 <P>Hi!</P><P>usethis:</P><P>Data:<BR />LOAD * INLINE [<BR />ID, Article Name<BR />1, WW<BR />1, QE<BR />2, SS<BR />3, QZ<BR />3, QC<BR />3, QN<BR />4, QE<BR />5, KK<BR />6, JH<BR />6, LM<BR />6, TT<BR />6, PP<BR />];</P><P>Data_new:<BR />NoConcatenate<BR />load<BR />ID,<BR />Concat("Article Name",'/',) as "Article Name"<BR />resident Data<BR />group by ID;</P><P>drop table Data;</P> Wed, 29 May 2019 11:37:02 GMT https://community.qlik.com/t5/QlikView/Help-Needed/m-p/1586108#M443227 martinpohl 2019-05-29T11:37:02Z https://community.qlik.com/t5/QlikView/Help-Needed/m-p/1586122#M443228 Thanks Martin ,<BR />It worked <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Wed, 29 May 2019 12:09:20 GMT https://community.qlik.com/t5/QlikView/Help-Needed/m-p/1586122#M443228 kiranpatil123 2019-05-29T12:09:20Z