topic convert rows to columns in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317807#M1835170 <HTML><HEAD></HEAD><BODY><P>here&nbsp; there are 4 rows and 3 columns in one internal table and 6 columns ans 2 rows in other internal table. How to proceed</P><P></P><P>Itab1/wa1</P><P></P><P>s&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f3 </P><P></P><P>r1&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp; c</P><P></P><P>r2&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P><SPAN style="font-size: 10pt;">r3&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp; i</SPAN></P><P></P><P>r4&nbsp;&nbsp;&nbsp;&nbsp; j&nbsp;&nbsp;&nbsp;&nbsp; k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l</P><P></P><P>o/p</P><P></P><P>itab2/wa2</P><P></P><P>s&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f3&nbsp;&nbsp;&nbsp;&nbsp; f4&nbsp;&nbsp;&nbsp;&nbsp; f5&nbsp;&nbsp;&nbsp;&nbsp; f6</P><P></P><P>r1&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>r2&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; j&nbsp;&nbsp;&nbsp;&nbsp; k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P></P><P>How to proceed??</P><P>help me out</P></BODY></HTML> Sat, 31 May 2014 05:22:25 GMT Former Member 2014-05-31T05:22:25Z convert rows to columns https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317807#M1835170 <HTML><HEAD></HEAD><BODY><P>here&nbsp; there are 4 rows and 3 columns in one internal table and 6 columns ans 2 rows in other internal table. How to proceed</P><P></P><P>Itab1/wa1</P><P></P><P>s&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f3 </P><P></P><P>r1&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp; c</P><P></P><P>r2&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P><SPAN style="font-size: 10pt;">r3&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp; i</SPAN></P><P></P><P>r4&nbsp;&nbsp;&nbsp;&nbsp; j&nbsp;&nbsp;&nbsp;&nbsp; k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l</P><P></P><P>o/p</P><P></P><P>itab2/wa2</P><P></P><P>s&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f3&nbsp;&nbsp;&nbsp;&nbsp; f4&nbsp;&nbsp;&nbsp;&nbsp; f5&nbsp;&nbsp;&nbsp;&nbsp; f6</P><P></P><P>r1&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>r2&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; j&nbsp;&nbsp;&nbsp;&nbsp; k&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P></P><P>How to proceed??</P><P>help me out</P></BODY></HTML> Sat, 31 May 2014 05:22:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317807#M1835170 Former Member 2014-05-31T05:22:25Z Re: convert rows to columns https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317808#M1835171 <HTML><HEAD></HEAD><BODY><P>hi Soumya,</P><P></P><P>Can you please share the exact table and values. how are these related to each other.</P><P></P><P>Based on that information I can suggest a logic. </P><P></P><P>Regards,</P><P>DN.</P></BODY></HTML> Mon, 02 Jun 2014 09:20:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317808#M1835171 Former Member 2014-06-02T09:20:57Z Re: convert rows to columns https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317809#M1835172 <HTML><HEAD></HEAD><BODY><P>Welcome to SCN! Please make sure to use Google before posting new questions. Similar questions have already been answered before, just google 'transpose site:scn.sap.com'.</P></BODY></HTML> Mon, 02 Jun 2014 16:29:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317809#M1835172 Jelena_Perfiljeva 2014-06-02T16:29:22Z Re: convert rows to columns https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317810#M1835173 <HTML><HEAD></HEAD><BODY><P>in ITAB1/WA1 there are 3 field and 4 records</P><P>in ITAB2/WA2 there are 6 fields</P><P>the 1st 2 records in ITAB1 should append into the 1st record of ITAB2</P><P>and the next 2 records in ITAB1 should append into the 2nd record of ITAB2</P></BODY></HTML> Tue, 03 Jun 2014 12:40:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317810#M1835173 Former Member 2014-06-03T12:40:54Z Re: convert rows to columns https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317811#M1835174 <HTML><HEAD></HEAD><BODY><P>ya sure thank you...</P></BODY></HTML> Tue, 03 Jun 2014 12:41:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/convert-rows-to-columns/m-p/10317811#M1835174 Former Member 2014-06-03T12:41:24Z