Data transforming

[renjankj]

Hi All,

I have a large set of data which need to be transformed to a specific format.

I have attached screenshot on how i want it

Can you please help with a solution

[atcodedog05]

Hi @renjankj 

Can you provide this excel file.

[renjankj]

please see the excel file

[atcodedog05]

Hi @renjankj 

Here is how you can do it.

Hope this helps : )

[nagakavyasri · Accepted solution]

Another way if there are multiple columns

[atcodedog05]

Hi @renjankj 

Another approach is the column name are changing

Hope this helps : )

[Raj]

@renjankj 
find the workflow attached
mark done if solved.

[grazitti_sapna]

You can try the below workflow to get the desired output. Let me know if it works for you or not.
Let me know if your requirement is something else.

Thanks
Sapna