How to Copy Transpose excel table data

[Gokul001 (Gokul Balaji)]

Hi @Mulya_Habibi_Tullah1

First you need to Read the input excel file.

And you need to Use Filter Data Table activity → You this As an Input DataTable.

Try with this below

• you can use the Copy/Paste Range activity to transpose Excel data or data table.

• You need to provide the source range and the destination range where you want to paste the transposed data.

• You also need to check the Transpose option in the activity properties

Check out this docs

https://docs.uipath.com/studiox/v2019/docs/copy-paste-range-x

Check out this Tutorial

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
Gokul