topic Need help transposing a single column of data into 3 columns every fourth cell needs to be a new row in Report Server https://community.fabric.microsoft.com/t5/Report-Server/Need-help-transposing-a-single-column-of-data-into-3-columns/m-p/3337455#M30566 <P>I have something like this:</P><P class="lia-indent-padding-left-30px">app type record 1</P><P class="lia-indent-padding-left-30px">requstor of app 1</P><P class="lia-indent-padding-left-30px">requested on 1</P><P class="lia-indent-padding-left-30px">app type record 2</P><P class="lia-indent-padding-left-30px">requstor of app 2</P><P class="lia-indent-padding-left-30px">requested on 2</P><P class="lia-indent-padding-left-30px">app type record 3</P><P class="lia-indent-padding-left-30px">requstor of app 3</P><P class="lia-indent-padding-left-30px">requested on 3</P><P>I need it to be like this:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>App Type</TD><TD>Requestor</TD><TD>Requested on</TD></TR></TBODY></TABLE><DIV><DIV>&nbsp;</DIV></DIV><DIV><DIV><DIV>&nbsp;</DIV></DIV></DIV><DIV><DIV>&nbsp;</DIV></DIV><DIV><DIV><DIV><DIV>&nbsp;</DIV></DIV></DIV></DIV><DIV><DIV>&nbsp;</DIV></DIV><DIV><DIV><DIV>&nbsp;</DIV></DIV></DIV><DIV><DIV>&nbsp;</DIV></DIV> Wed, 19 Jul 2023 00:41:42 GMT SomeGuy-leaning 2023-07-19T00:41:42Z Need help transposing a single column of data into 3 columns every fourth cell needs to be a new row https://community.fabric.microsoft.com/t5/Report-Server/Need-help-transposing-a-single-column-of-data-into-3-columns/m-p/3337455#M30566 <P>I have something like this:</P><P class="lia-indent-padding-left-30px">app type record 1</P><P class="lia-indent-padding-left-30px">requstor of app 1</P><P class="lia-indent-padding-left-30px">requested on 1</P><P class="lia-indent-padding-left-30px">app type record 2</P><P class="lia-indent-padding-left-30px">requstor of app 2</P><P class="lia-indent-padding-left-30px">requested on 2</P><P class="lia-indent-padding-left-30px">app type record 3</P><P class="lia-indent-padding-left-30px">requstor of app 3</P><P class="lia-indent-padding-left-30px">requested on 3</P><P>I need it to be like this:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>App Type</TD><TD>Requestor</TD><TD>Requested on</TD></TR></TBODY></TABLE><DIV><DIV>&nbsp;</DIV></DIV><DIV><DIV><DIV>&nbsp;</DIV></DIV></DIV><DIV><DIV>&nbsp;</DIV></DIV><DIV><DIV><DIV><DIV>&nbsp;</DIV></DIV></DIV></DIV><DIV><DIV>&nbsp;</DIV></DIV><DIV><DIV><DIV>&nbsp;</DIV></DIV></DIV><DIV><DIV>&nbsp;</DIV></DIV> Wed, 19 Jul 2023 00:41:42 GMT https://community.fabric.microsoft.com/t5/Report-Server/Need-help-transposing-a-single-column-of-data-into-3-columns/m-p/3337455#M30566 SomeGuy-leaning 2023-07-19T00:41:42Z Re: Need help transposing a single column of data into 3 columns every fourth cell needs to be a new row https://community.fabric.microsoft.com/t5/Report-Server/Need-help-transposing-a-single-column-of-data-into-3-columns/m-p/3339148#M30574 <P><img /></P><P>So, data set is like this on the left. I'm looking to get it into something like the right?&nbsp;</P> Wed, 19 Jul 2023 16:46:41 GMT https://community.fabric.microsoft.com/t5/Report-Server/Need-help-transposing-a-single-column-of-data-into-3-columns/m-p/3339148#M30574 SomeGuy-leaning 2023-07-19T16:46:41Z