Transpose

[guptasweb]

How to insert the data horizontally in excel.

[omer.ozturk (Ömer Öztürk)]

Hi @guptasweb,

Please check this topic.

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…

Regards
Ömer

[sunilch (sunil)]

Hi Gupta,

You can try linq query as below or use nested loops, one for columns and other rows

Regards,
Sunil

[guptasweb]

in which activity it is used?

[Rahul_Unnikrishnan]

Hello @guptasweb

You can check the below post. You can use that custom activity to transpose. Or another method is there in the second post.

How to transpose row to column in datatable?

hello @saintseiyer You can add all values in a list and than use add data row activity to add in a table please check the below workflow for better understanding Coltorows.xaml (16.4 KB)

How To Transpose DataTable - In UiPath - ExcelCult

Thanks