topic Table transpose in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-transpose/m-p/3072859#M728527 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P>I have data in the below format.</P><P>Category Month Value</P><P>A JAN 10</P><P>C FEB 20</P><P>B MAR 30 </P><P>D MAY 40</P><P>E APR 50</P><P>F JAN 60</P><P>F FEB 70</P><P>-</P><HR originaltext="---" /><P> LIKE THIS.</P><P></P><P>i want to make report in given format.</P><P>Category JAN FEB MAR APR MAY JUN ...........</P><P>A----</P><HR originaltext="-------" /><P> 10 0 0 0 0 0</P><P>B----</P><HR originaltext="-------" /><P> 0 0 30 0 0 0</P><P>C----</P><HR originaltext="-------" /><P> 0 20 0 0 0 0</P><P>D----</P><HR originaltext="-------" /><P> 0 0 0 0 40 0</P><P>E----</P><HR originaltext="-------" /><P> 50 0 0 0 0 0</P><P>F----</P><HR originaltext="-------" /><P> 60 70 0 0 0 0</P><P></P><P>The above data should come under the assigned months,</P><P></P><P>Thaks &amp; regards</P><P>Anwar</P></BODY></HTML> Thu, 22 Nov 2007 11:39:06 GMT Former Member 2007-11-22T11:39:06Z Table transpose https://community.sap.com/t5/application-development-and-automation-discussions/table-transpose/m-p/3072859#M728527 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P>I have data in the below format.</P><P>Category Month Value</P><P>A JAN 10</P><P>C FEB 20</P><P>B MAR 30 </P><P>D MAY 40</P><P>E APR 50</P><P>F JAN 60</P><P>F FEB 70</P><P>-</P><HR originaltext="---" /><P> LIKE THIS.</P><P></P><P>i want to make report in given format.</P><P>Category JAN FEB MAR APR MAY JUN ...........</P><P>A----</P><HR originaltext="-------" /><P> 10 0 0 0 0 0</P><P>B----</P><HR originaltext="-------" /><P> 0 0 30 0 0 0</P><P>C----</P><HR originaltext="-------" /><P> 0 20 0 0 0 0</P><P>D----</P><HR originaltext="-------" /><P> 0 0 0 0 40 0</P><P>E----</P><HR originaltext="-------" /><P> 50 0 0 0 0 0</P><P>F----</P><HR originaltext="-------" /><P> 60 70 0 0 0 0</P><P></P><P>The above data should come under the assigned months,</P><P></P><P>Thaks &amp; regards</P><P>Anwar</P></BODY></HTML> Thu, 22 Nov 2007 11:39:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-transpose/m-p/3072859#M728527 Former Member 2007-11-22T11:39:06Z Re: Table transpose https://community.sap.com/t5/application-development-and-automation-discussions/table-transpose/m-p/3072860#M728528 <HTML><HEAD></HEAD><BODY><P>Hi Anwar,</P><P></P><P> Check this link</P><P></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="4434231"></A></P><P></P><P>&lt;b&gt;Reward Points if this helps,&lt;/b&gt;</P><P></P><P>Satish</P></BODY></HTML> Thu, 22 Nov 2007 11:51:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-transpose/m-p/3072860#M728528 Former Member 2007-11-22T11:51:25Z