Workflows – using the Transpose block
Last updated
Last updated
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.
Gross Sales | Net Sales | Total Sales |
---|---|---|
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
5226.40
4147.81
4286.89