---
title: "silreporting_transposeTable"
canonical: "https://support.appfire.com/space/PSJ/15482590/silreporting_transposeTable"
format: markdown
---
> Macro (aura-html)


## Syntax

**<span style="color: #3366ff">silreporting_transposeTable(silTable[, transposedHeaders])</span>**

## Description

> Macro (excerpt)
> 
> Transpose the specified table.

## Parameters

| Parameter name | Type | Required | Description |
| --- | --- | --- | --- |
| silTabel | SILReportingTable | Yes | The table to be transposed. |
| transposedHeaders | <span style="color: #003366">SILReportingHeader []</span> | No | List of headers that should be displayed for the transposed table. |

## Return type

**SILReportingTable**

The transposed table.

## Example

In the fallowing example you can see a transposed table which contains the number of opened and resolved issues for a list of projects.

```
string [] projects = "TEST|FIBR|STEI|GRBI|HGES|RGIS";
string [] resolvedIssues;
string [] openedIssues;
for(string p in projects) {
    resolvedIssues[p] += countIssues("project = " + p  + " AND status in (Done, Closed, Resolved)");
    openedIssues[p] += countIssues("project = " + p  + " AND status not in (Done, Closed, Resolved)");
}
    
SILReportingHeader [] headers;

SILReportingHeader h1;
h1.name = "Opened Issues";
h1.sortable = "sortable";
headers += h1;
    
SILReportingHeader h2;
h2.name = "Resolved Issues";
h2.sortable = "sortable";
headers += h2;

string [][] rows;
for(string p in projects){
    rows += {openedIssues[p], resolvedIssues[p]};
}

SILReportingTable table;
table.headers = headers;
table.rows = rows;


SILReportingHeader [] transposedHeaders;
for(string p in projects){
    SILReportingHeader h;
    h.name = p;
    h.sortable = "sortable";
    transposedHeaders += h;
}

return silreporting_transposeTable(table, transposedHeaders);
```

![image](media://9c49c88a-d9de-4eb0-a7f7-7b73e8b45140)