https://community.sap.com/t5/application-development-and-automation-discussions/converting-columns-to-row/m-p/3163385#M752444 <HTML><HEAD></HEAD><BODY><P>Hi Kinjal,</P><P></P><P> Question is not clear. You want to change the internal table values with 6 columns &amp; 4 rows to 4 columns &amp; 6 rows?</P><P></P><P> If my understanding is correct, check the bleow logic:</P><P></P><P>loop at itab1.</P><P> case sy-tabix.</P><P> when 1.</P><P> itab2-c1 = itab1-c1.</P><P> append itab2.</P><P> itab2-c1 = itab1-c2.</P><P> append itab2.</P><P> itab2-c1 = itab1-c3.</P><P> append itab2.</P><P> itab2-c1 = itab1-c4.</P><P> append itab2.</P><P> itab2-c1 = itab1-c5.</P><P> append itab2.</P><P> itab2-c1 = itab1-c6.</P><P> append itab2.</P><P> when 2.</P><P> itab2-c2 = itab1-c1.</P><P> modify itab2 transporting c2 index 1.</P><P> itab2-c2 = itab1-c2.</P><P> modify itab2 transporting c2 index 2.</P><P> itab2-c2 = itab1-c3.</P><P> modify itab2 transporting c2 index 3.</P><P> itab2-c2 = itab1-c4.</P><P> modify itab2 transporting c2 index 4.</P><P> itab2-c2 = itab1-c5.</P><P> modify itab2 transporting c2 index 5.</P><P> itab2-c2 = itab1-c6.</P><P> modify itab2 transporting c2 index 6.</P><P></P><P> when 3.</P><P> itab2-c3 = itab1-c1.</P><P> modify itab2 transporting c3 index 1.</P><P> ....</P><P> ....</P><P> when 4.</P><P> itab2-c4 = itab1-c1.</P><P> modify itab2 transporting c4 index 1.</P><P> ....</P><P> ....</P><P>Endloop.</P><P></P><P> Finally you will get 6 rows with 4 coulmns.</P></BODY></HTML> Tue, 18 Dec 2007 01:58:29 GMT Former Member 2007-12-18T01:58:29Z https://community.sap.com/t5/application-development-and-automation-discussions/converting-columns-to-row/m-p/3163384#M752443 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 6 columns and 4 rows and i want to convert it into 6 rows and 4 columns and want to display in table control.</P><P></P><P></P><P>plz help me in this ....</P></BODY></HTML> Tue, 18 Dec 2007 01:40:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/converting-columns-to-row/m-p/3163384#M752443 Former Member 2007-12-18T01:40:30Z https://community.sap.com/t5/application-development-and-automation-discussions/converting-columns-to-row/m-p/3163385#M752444 <HTML><HEAD></HEAD><BODY><P>Hi Kinjal,</P><P></P><P> Question is not clear. You want to change the internal table values with 6 columns &amp; 4 rows to 4 columns &amp; 6 rows?</P><P></P><P> If my understanding is correct, check the bleow logic:</P><P></P><P>loop at itab1.</P><P> case sy-tabix.</P><P> when 1.</P><P> itab2-c1 = itab1-c1.</P><P> append itab2.</P><P> itab2-c1 = itab1-c2.</P><P> append itab2.</P><P> itab2-c1 = itab1-c3.</P><P> append itab2.</P><P> itab2-c1 = itab1-c4.</P><P> append itab2.</P><P> itab2-c1 = itab1-c5.</P><P> append itab2.</P><P> itab2-c1 = itab1-c6.</P><P> append itab2.</P><P> when 2.</P><P> itab2-c2 = itab1-c1.</P><P> modify itab2 transporting c2 index 1.</P><P> itab2-c2 = itab1-c2.</P><P> modify itab2 transporting c2 index 2.</P><P> itab2-c2 = itab1-c3.</P><P> modify itab2 transporting c2 index 3.</P><P> itab2-c2 = itab1-c4.</P><P> modify itab2 transporting c2 index 4.</P><P> itab2-c2 = itab1-c5.</P><P> modify itab2 transporting c2 index 5.</P><P> itab2-c2 = itab1-c6.</P><P> modify itab2 transporting c2 index 6.</P><P></P><P> when 3.</P><P> itab2-c3 = itab1-c1.</P><P> modify itab2 transporting c3 index 1.</P><P> ....</P><P> ....</P><P> when 4.</P><P> itab2-c4 = itab1-c1.</P><P> modify itab2 transporting c4 index 1.</P><P> ....</P><P> ....</P><P>Endloop.</P><P></P><P> Finally you will get 6 rows with 4 coulmns.</P></BODY></HTML> Tue, 18 Dec 2007 01:58:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/converting-columns-to-row/m-p/3163385#M752444 Former Member 2007-12-18T01:58:29Z