Transpose the excel sheet data

[Aarthy1 (Aarthy)]

I want to transpose the input excel file to output excel file .
Here I attached the examples file also plz help me to resolve
In input excel data is dynamic ( it change the count in next month)
output.xlsx (16.7 KB)
Input.xlsx (16.8 KB)

[raja.arslankhan]

Good Morning @Aarthy1,
I am looking your problem

[Gokul001 (Gokul Balaji)]

Hi @Aarthy1

Have a look on the thread

How to move row items to column(Transpose) in excel using UiPath

Hi, I came across a scenario where I needed to move row values to column /, in other words, transpose. In another similar thread, I found a package that does the work, but I want to learn to make it happen without the use of packages and do it a hard way, can anyone help me with this? Thank you.

How To Transpose DataTable – In UiPath

Regards
Gokul

[raja.arslankhan]

Step 1:
Drag “Excel application scope” and “Read Range” activities into the designer panel to read the input excel

Step 2:
Drag “While“, “Add Data Column” and “Assign” activities into the designer panel to create dummy columns
(Because here we are transposing the headers too)

Step 3:
Drag “For Each Row“, “While“, “Add Data Row” and “Assign” activities into the designer panel and write the logic to convert rows to columns.

Step 4:
Finally, execute the workflow to see the results

[supermanPunch (Arpan)]

Hi @Aarthy1 ,

Could you try checking the output with the Component below :

Novigo Solutions - Transpose DataTable - RPA Component | UiPath Marketplace

[Gokul001 (Gokul Balaji)]

HI @Aarthy1

Install the NovigoSolutions.TransposeDataTable

Have a look on the XAML file

Transpose.xaml (7.0 KB)

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

Hello @Aarthy1 , Try this
By using modern excel activities , we can transpose the data using copy paste activity
Kindly refer this flow, It may helps you
Forum_TransposeData.zip (85.7 KB)

To enable the activities, Click filter on activity pannel and select the show modern

select the transpose option in the copy paste activity

Regards,
Gokul Jai