https://community.qlik.com/t5/QlikView/Merge-two-rows-into-one/m-p/1920109#M1218519 <P>Hi,</P> <P>You can just concatenate rows. For this, you should load the original data, and load it again, but rename row1 as row2. See example below</P> <P>Data:<BR />LOAD * Inline[<BR />row1, row2<BR />hmc1, hmc4<BR />hmc2, hmc5<BR />hmc3, hmc6<BR />];</P> <P>Concatenate(Data)<BR />LOAD<BR />row2 as row1<BR />Resident Data;</P> <P>Result:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vchuprina_0-1650402940657.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/77441iA850ADDB75B72496/image-size/medium?v=v2&amp;px=400" role="button" title="vchuprina_0-1650402940657.png" alt="vchuprina_0-1650402940657.png" /></span></P> <P>&nbsp;</P> <P>Regards,</P> <P>Vitalii</P> Tue, 19 Apr 2022 21:13:15 GMT vchuprina 2022-04-19T21:13:15Z https://community.qlik.com/t5/QlikView/Merge-two-rows-into-one/m-p/1920063#M1218518 <P>I wanted to add two rows data into one row</P> <P>row1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row2</P> <P>hmc1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hmc4</P> <P>hmc2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hmc5</P> <P>hmc3&nbsp;&nbsp;&nbsp;&nbsp; hmc6</P> <P>---------------------------------------</P> <P>merge_row</P> <P>hmc1</P> <P>hmc2</P> <P>hmc3</P> <P>hmc4</P> <P>hmc5</P> <P>hmc6</P> Tue, 19 Apr 2022 17:48:30 GMT https://community.qlik.com/t5/QlikView/Merge-two-rows-into-one/m-p/1920063#M1218518 New_Bee77 2022-04-19T17:48:30Z https://community.qlik.com/t5/QlikView/Merge-two-rows-into-one/m-p/1920109#M1218519 <P>Hi,</P> <P>You can just concatenate rows. For this, you should load the original data, and load it again, but rename row1 as row2. See example below</P> <P>Data:<BR />LOAD * Inline[<BR />row1, row2<BR />hmc1, hmc4<BR />hmc2, hmc5<BR />hmc3, hmc6<BR />];</P> <P>Concatenate(Data)<BR />LOAD<BR />row2 as row1<BR />Resident Data;</P> <P>Result:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vchuprina_0-1650402940657.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/77441iA850ADDB75B72496/image-size/medium?v=v2&amp;px=400" role="button" title="vchuprina_0-1650402940657.png" alt="vchuprina_0-1650402940657.png" /></span></P> <P>&nbsp;</P> <P>Regards,</P> <P>Vitalii</P> Tue, 19 Apr 2022 21:13:15 GMT https://community.qlik.com/t5/QlikView/Merge-two-rows-into-one/m-p/1920109#M1218519 vchuprina 2022-04-19T21:13:15Z