Write the data in data table to one row

Dear all,

I have the excel file like in the image.
image
I want to create the result file to one row like this
image

Any idea on this case. Please help me some idea. Thanks all

Can I have your full requirement?. Then easy to give straight solution

Hi @kiddervn ,
You can see the attached workflow for your situation.
There is a restriction on column names so you cannot use the same name again. I modified the name of the columns by adding the row index so I could test the flow.(eg: Name,Value,Name1,Value1,Name2,Value2…etc).

OneRow.zip (27.1 KB)

I hope it is helpful!

1 Like

Thank for guide me. It’s helpful for me.

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