How to transpose column to row

[Robert_Lansbergen (RJL)]

Hi @dvojinovic,

There should be an option in the append range activity.

Activities - Append Range

This activity should be in the modern design activities.

Or check this post:

Transpose column to row in DataTable

Hello Frients, I want to transpose column to row and also concatenate values by semicolon separated. Here is example. I can transpose column values for first 2 rows but how can I build 3rd column from rest of the rows? InputDT [image] OutputDT [image] P.S: I built empty dataTable to have column names in OutputDT. @Palaniyappan: Can you also help me achieving required output? Thanks & Regards, Navneet Happy Automation!

Kind regards,
Robert