Transpose Table Data

Queries and Resources
1

Is there a way to easily transpose the rows in a table to columns?

2

Just to clarify, the table consists of 1 header row and 1 row of data which needs to be transposed into 1 column with the header data and another column with the data.

3

@ChrisV

Hey there :wave: Thanks for reaching out! Would you mind sharing a screenshot of what your data and table look like currently? Here is a link to our docs on Data Conversion in case that is useful :slightly_smiling_face:

If you are looking to turn your rows into columns, a teammate of mine wrote out a way to do this! You can use Javascript in a transformer or between double curly brackets {{}} to manipulate the data in the way you're looking for.

Here's the example:

2576×1720 450 KB

1 Like
4

@lauren.gus Thanks for the reply. Here is a screenshot of current layout. Based upon the screenshots, how do you think the javascript should be modified to create the transpose? Going to give the transformer a try, but any insight is appreciated.

image
image1433×121 11.9 KB

5

Sample transpose
image

6

@lauren.gus This worked well with:

let arr=[]
data.map(x=>{
	Object.entries(x).map(x=>arr.push(x)
	)})
return arr

Thanks for the help.