Transpose the excel sheet data

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)

Good Morning @Aarthy1,
I am looking your problem

Hi @Aarthy1

Have a look on the thread

Regards
Gokul

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

UiPath DataTable Transpose 1.PNG

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)

UiPath DataTable Transpose 2.PNG

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

UiPath DataTable Transpose 4

Hi @Aarthy1 ,

Could you try checking the output with the Component below :

HI @Aarthy1

Install the NovigoSolutions.TransposeDataTable

Have a look on the XAML file

Transpose.xaml (7.0 KB)

image

Regards
Gokul

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
image

Regards,
Gokul Jai

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.