PocketQuery Data Center FAQ Current: How to pivot a PocketQuery result table (transpose, juxtapose) How to pivot a PocketQuery result table (transpose, juxtapose) ExampleThis table:abcdefghiShould become this:adgbehcfiHow ToGo to the PocketQuery AdministrationGo to "Templates" and click on "Add template"Name it "pivot" and copy & paste following code into "content" <table class="aui confluenceTable pocketquery-table"> <tbody> #foreach ($column in $columns) <tr> <td style="background-color: #f0f0f0; font-weight: bold;"> $column </td> #foreach($row in $result) <td> $!row.get($column) </td> #end </tr> #end </tbody> </table> CODE Go to a query and select "pivot" as template ×