https://community.qlik.com/t5/QlikView/Grouping-values/m-p/1563135#M743413 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject"><SPAN>I have two columns of data in Excel:</SPAN></DIV></DIV></DIV><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>1. FAMILY CODE</P><P>2. NAME</P><P>How do i group the lines from&nbsp;NAME Column&nbsp; by FAMILY CODE</P><P>Here is a example:</P><P><STRONG>FAMILY CODE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NAME</STRONG><BR />46739723&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANTONIO CARLOS<BR />46739723&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JOANA MARIA<BR />49643062&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FERNANDA LIMA<BR />49643062&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TENORIO DE CAMPOS<BR />49643735&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ARMANDO FERNANDES<BR />49643735&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANDERSON ANTUNES</P></DIV></DIV> Wed, 25 Nov 2020 16:16:04 GMT srcapille 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Grouping-values/m-p/1563135#M743413 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject"><SPAN>I have two columns of data in Excel:</SPAN></DIV></DIV></DIV><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>1. FAMILY CODE</P><P>2. NAME</P><P>How do i group the lines from&nbsp;NAME Column&nbsp; by FAMILY CODE</P><P>Here is a example:</P><P><STRONG>FAMILY CODE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NAME</STRONG><BR />46739723&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANTONIO CARLOS<BR />46739723&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JOANA MARIA<BR />49643062&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FERNANDA LIMA<BR />49643062&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TENORIO DE CAMPOS<BR />49643735&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ARMANDO FERNANDES<BR />49643735&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANDERSON ANTUNES</P></DIV></DIV> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Grouping-values/m-p/1563135#M743413 srcapille 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Grouping-values/m-p/1563136#M743414 Try something like this<BR /><BR />Load<BR />[FAMILY CODE],<BR />Concat(NAME, ',') AS NAMES<BR />FROM ExcelFile<BR />Group by [FAMILY CODE]<BR />; Sat, 30 Mar 2019 17:54:05 GMT https://community.qlik.com/t5/QlikView/Grouping-values/m-p/1563136#M743414 Vegar 2019-03-30T17:54:05Z