Workflows – using the Transpose block
Let's say we have metric sums for specific time periods, and each metric has its own column. Now, we want to transform each metric into a separate row.
To achieve this, we can use the Transpose block, which switches columns to rows and vice versa. Here is how our Workflow layout setup would look like
![](https://storage.crisp.chat/users/helpdesk/website/39e5340fb975fe00/transpose_1piysxm.png)
Let's run this Workflow and view the results.
Gross Sales | Net Sales | Total Sales |
---|---|---|
5226.40 | 4147.81 | 4286.89 |
To achieve this, we can use the Transpose block, which switches columns to rows and vice versa. Here is how our Workflow layout setup would look like
![](https://storage.crisp.chat/users/helpdesk/website/39e5340fb975fe00/transpose_1piysxm.png)
Let's run this Workflow and view the results.
Name | Column1 |
---|---|
Gross Sales | $5,226.40 |
Net Sales | $4,147.81 |
Total Sales | $4,286.89 |
Updated on: 15/03/2024
Thank you!