How to transpose column to row in data table?

[makboga]

Hİ,
I have an excel file like this,

I want to change this excel columns to this

and want to write this datas in a new excel file.

Thank you.

[supermanPunch (Arpan)]

Hi @makboga ,

Try Checking on the methods present in the below post :

How to Transpose Excel data or Data Table?

Hello UiPathans Here we discuss how to Transpose the data in Excel or a data table What is meant by Transpose? Input [image] Output [image] Transpose can achieve by two methods → Modern activity- Using Copy/Paste range Activity.(For Excel Processing) → Novigo Solutions. (For Datatable Processing) Modern activity- Copy/Paste range Activity. By Using modern activity we can achieve the transpose method. For classic users can select Show Modern from the Activit…

Let us know if it doesn’t work as expected.

[makboga]

Thank you so much

[Gokul001 (Gokul Balaji)]

Hi @makboga

Check out the Video link

LINQ | Transpose Datatable Uipath | LINQ Transpose Datatable | Uipath Tutorials | Coderslobby

How to Transpose Row to Column in Data Table in Uipath | Uipath RPA

Check out this thread

How to transpose row to column in datatable?

Hello @saintseiyer I have recently published an UiPath activity pack which includes a data transpose activity. You can easily get your data transposed as you need using this single activity. https://go.uipath.com/component/data-manipulations# Make sure to go through the activity guide document on how it can be configured…

Regards
Gokul