https://community.blueprism.com/t5/Product-Forum/Transpose-Values-into-Columns/m-p/79118#M31064 Hi all,<BR /><BR />I am trying to figure out the way to transpose values into columns. In the attached example the dataset2 headers consists of the row of distinct values from dataset1&nbsp; The values from col0 ( dataset1) are mapped against the same values in dataset2 columns.&nbsp;<BR />The bottom line is that I need come from dataset1 to dataset2.<BR /><BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"> <DIV class="media" style="overflow: hidden; zoom: 1;"><STRONG><STRONG></STRONG></STRONG> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="18695.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/18844iBCC614D983D33478/image-size/large?v=v2&amp;px=999" role="button" title="18695.png" alt="18695.png" /></span></DIV> </DIV> </DIV> <BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="18697.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/18848i1C6C7F877754BDFE/image-size/large?v=v2&amp;px=999" role="button" title="18697.png" alt="18697.png" /></span></DIV><BR /><BR />------------------------------<BR />What doesn't kill us makes us stronger<BR />------------------------------<BR /> Tue, 22 Oct 2019 21:19:00 GMT TimurAkhmadulin 2019-10-22T21:19:00Z https://community.blueprism.com/t5/Product-Forum/Transpose-Values-into-Columns/m-p/79118#M31064 Hi all,<BR /><BR />I am trying to figure out the way to transpose values into columns. In the attached example the dataset2 headers consists of the row of distinct values from dataset1&nbsp; The values from col0 ( dataset1) are mapped against the same values in dataset2 columns.&nbsp;<BR />The bottom line is that I need come from dataset1 to dataset2.<BR /><BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"> <DIV class="media" style="overflow: hidden; zoom: 1;"><STRONG><STRONG></STRONG></STRONG> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="18695.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/18844iBCC614D983D33478/image-size/large?v=v2&amp;px=999" role="button" title="18695.png" alt="18695.png" /></span></DIV> </DIV> </DIV> <BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="18697.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/18848i1C6C7F877754BDFE/image-size/large?v=v2&amp;px=999" role="button" title="18697.png" alt="18697.png" /></span></DIV><BR /><BR />------------------------------<BR />What doesn't kill us makes us stronger<BR />------------------------------<BR /> Tue, 22 Oct 2019 21:19:00 GMT https://community.blueprism.com/t5/Product-Forum/Transpose-Values-into-Columns/m-p/79118#M31064 TimurAkhmadulin 2019-10-22T21:19:00Z