Transpose the data of rows and columns

[ramshiva_reddy]

Hello Team,

Can we transpose the data from excel for multiple rows.

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

try excel copy/paste activity

with transpose option checked

Regards

[Parvathy (PS Parvathy)]

Hi @ramshiva_reddy

Please find the below link to transpose the data in an excel.

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

Hope it helps!!
Regards,

[Gokul_Jayakumar (Gokul Jai)]

Hello @ramshiva_reddy , Welcome to UiPath Community.
Kindly check this thread, you will get some idea.

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…