Skip to main content
A
ashwinir5622
March 11, 2026
Question

Transpose data in excel to vertical columns rather than horizontal columns

  • March 11, 2026
  • 1 reply
  • 0 views

I am using Export DSE to Excel node so currently, the data in each tab of the Export uses the default horizontal (normal) formatting.  The user would like to have the columns transposed to Vertical formatting when the Excel is created.

Excel tab show the data in vertical rather than horizontal.  So, column A would have all of the column headers, Column B  & Column C should hold the related data and so forth. Kindly give your suggestions

From this to 

To this

1 reply

revathis772076
revathis772076
March 11, 2026

Try this, hope it helps.

a!localVariables(
local!rowLabels: { "Brand", "Product", "Code" },
local!rowData: {
row1: { "B1", "B2", "B3" },
row2: { "Pro1", "Pro2", "Pro3" },
row3: { "C001", "C002", "C003" }
},
local!rowMap: a!forEach(
items: local!rowLabels,
expression: a!flatten(
{
fv!item,
a!match(
value: fv!index,
equals: 1,
then: local!rowData.row1,
equals: 2,
then: local!rowData.row2,
default: local!rowData.row3
)
}
)
),
a!forEach(
items: local!rowMap,
expression: a!map(
column1: index(fv!item, 1, null),
column2: index(fv!item, 2, null),
column3: index(fv!item, 3, null),
column4: index(fv!item, 4, null)
)
)
)

Terms & ConditionsAccessibility statement