Transpose Column to row and keep value in columns

I have following table:
Height value Height limit Height Result Length value Length limit Length Result
10 11 12 13 14 15

I want to transform it into:
Value Limit Result

Height 10 11 12
Length 13 14 15

I have Unpivot it and now I have table like this
column Val
Height value 10
Height limit 11
Height Result 12
Length value 13
Length limit 14
Length Result 15
Not sure how to proceed further. Any help will be much appreciated

Hi @richakaundal

first welcome to the forum.

refering to your question I recommend
1st) Split the column “column” to get Parametername and -type in seperate columns e.g.
Column 1: Height
Column 2: value
Column 3: 10

then use

2nd) pivot node with “Column 1” as group condition, “Column 2” as pivot condition and “Column 3” as aggregation type with aggregation option first.

BR

1 Like

Sorry, I forgot to mention there are multiple rows like :
Height value Height limit Height Result Length value Length limit Length Result Line
10 11 12 13 14 15 1
16 17 18 19 20 21 2
22 23 24 25 26 27 3
and I don’t want to aggregate those, I want output to be like

            value        limit    result      Line

Height1 10 11 12 1
Height 2 16 17 18 2
Height 3 22 23 24 3
Length1 13 14 15 1
Length2 19 20 21 2
Length3 25 26 27 3

Hi,
in this case add math formula node and return the rowindex before you use the unpivoting node. For unpivoting keep the rowindex column as retained and in the pivoting node as group condition.

BR

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.