https://community.qlik.com/t5/Talend-Studio/How-to-convert-excel-first-row-into-column/m-p/2218840#M13878 <P>&nbsp;</P> <P>Here is a solution with SplitRow.&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TalendImage.JPG" style="width: 777px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2cF.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154741i70FE2C83B9687CAE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2cF.jpg" alt="0683p000009M2cF.jpg" /></span></SPAN></P> <P>&nbsp;</P> Mon, 28 Jan 2019 10:21:36 GMT akumar2301 2019-01-28T10:21:36Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-excel-first-row-into-column/m-p/2218839#M13877 <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.PNG" style="width: 374px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2ax.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156240i7ED514F0CEBD5B95/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2ax.png" alt="0683p000009M2ax.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.PNG" style="width: 200px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2b2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146071iD21853997EB4873F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2b2.png" alt="0683p000009M2b2.png" /></span></SPAN></P> <P>first one is my input file and second one is my expected output .</P> Fri, 25 Jan 2019 10:31:10 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-excel-first-row-into-column/m-p/2218839#M13877 Anonymous 2019-01-25T10:31:10Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-excel-first-row-into-column/m-p/2218840#M13878 <P>&nbsp;</P> <P>Here is a solution with SplitRow.&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TalendImage.JPG" style="width: 777px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2cF.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154741i70FE2C83B9687CAE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2cF.jpg" alt="0683p000009M2cF.jpg" /></span></SPAN></P> <P>&nbsp;</P> Mon, 28 Jan 2019 10:21:36 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-excel-first-row-into-column/m-p/2218840#M13878 akumar2301 2019-01-28T10:21:36Z