How to convert matrix into wide table

Hello,I have a problem about following picture:


If possible, I hope it can be processed using process variables, because there are actually many rows of data to be processed.Any help would be much appreciated.

Hello @lca50666,

See if this solution helps.
Input data

Workflow

Output

Refer to this workflow
Convert to wide table.knwf (87.2 KB)

Regards,
Yogesh

3 Likes

@yogesh_nawale Thank you very much. Your method is also very good. I later added an extra row of Density and Conductivity data, and combined it with transpose and Pivot node to solve the problem.
image

1 Like

Hi @lca50666,

Thanks for the feedback. If you are satisfied with the solution, you can give green tick it as solution.

If you need more help, please ask.

Thanks and Regards,
Yogesh

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