Convert Column Values in Rows using Column Aggregator

[saiakula15]

Hi Team,

I have data in column wise and with same header and i would like to convert the data into rows.
I have used a Table Creator and Table Row to Variable Loop and i have defined fields in the Table Creator. when i was trying to concatenate the data using Column Aggregator i was unable to transform the right values.
Below is the screenshot of the data.

This is how the data should look in the O/P.

Below is a Screenshot workflow i am trying to use.

Thank You,
Sai A.

[HansS]

Hi @saiakula15

I went for a different approach convert_column_values.knwf (62.4 KB).

gr.Hans

.

[saiakula15]

Hi @HansS,

Thank you for your response, I have another question.
I have one extra field which changes every time and its in between ID and Field, Could you please suggest me any dynamic way to exclude or Rename those fields from the list.

Please review a sample file for your reference, i would like to elimincate the records which are marked in Yellow.
Sample_Output.xlsx (11.9 KB)

Thank you in Advance.

[saiakula15]

Hi @HansS,

I was able to solve the issue, Thank you so much for your help.

Thank you,
Sai Akula.