Transpose data in Excel

Hello All,

I have a situation where I extract data from different PDF files and the output is saved to an excel work book. Now

I need to transpose the data


Part Order Date Qty
A 01-Mar-21 40
A 03-Mar-21 100
A 10-Mar-21 40
B 01-Mar-21 40
B 03-Mar-21 100
B 10-Mar-21 40
B 01-Apr-21 250
B 04-Apr-21 100
C 01-Mar-21 67
C 03-Mar-21 34
C 10-Mar-21 56
C 04-Apr-21 59
C 01-May-21 90


01-Mar-21 03-Mar-21 10-Mar-21 01-Apr-21 04-Apr-21 01-May-21
A 40 100 40
B 40 100 40 250 100
C 67 34 56 59 90

Your thoughts and inputs would be highly appreciated.


Hi @manjesh_kumar

I had done a similar scenario

You can check the below worlflow for the logic part

sample (41.6 KB)

Mark it as solution if it resolves ur query


Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

I replaced the data in the input.xlsx with my data the workflow ran successfully however there was no output in sheet3.

The logic is complex and definitely it takes time for me to sink in.

Maybe a step by step comments would be really helpful for better understanding.


Can u Share the excel file please @manjesh_kumar

Hello @NIVED_NAMBIAR Input.xlsx (9.9 KB)

Hi @manjesh_kumar ,

Please find below a much simpler solution, using only Read/Write Range, Filter Data Table and Add Data Column UiPath activities

Please find here the help starter: TransposeDataInExcel.xaml (10.7 KB)

Hope this helps
Best regards,

1 Like

Dear @Marius_Puscasu,

That works well and serves the purpose. Thank you. :clap:

@NIVED_NAMBIAR Thank you also for your efforts.


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