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

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

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!