Transpose the excel sheet data

Help Studio
,
1

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)

2

Good Morning @Aarthy1,
I am looking your problem

3

Hi @Aarthy1

Have a look on the thread

Regards
Gokul

4

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.

UiPath DataTable Transpose 3.PNG
UiPath DataTable Transpose 3.PNG276×552 7.24 KB

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

UiPath DataTable Transpose 4

5

Hi @Aarthy1 ,

Could you try checking the output with the Component below :

6

HI @Aarthy1

Install the NovigoSolutions.TransposeDataTable

image
image903×595 54.2 KB

Have a look on the XAML file

Transpose.xaml (7.0 KB)

image

Regards
Gokul

7

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

image
image290×504 15 KB

select the transpose option in the copy paste activity
image

Regards,
Gokul Jai

1 Like
8

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