Transpose data in Excel

[manjesh_kumar]

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

Source

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

to

	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.

Regards,
Manjesh

[NIVED_NAMBIAR (NIVED N)]

Hi @manjesh_kumar

I had done a similar scenario

You can check the below worlflow for the logic part

sample workflow.zip (41.6 KB)

Mark it as solution if it resolves ur query

Regards

Nived N

Happy Automation

[manjesh_kumar]

Dear @NIVED_NAMBIAR ,
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.

Regards,
Manjesh

[NIVED_NAMBIAR (NIVED N)]

Can u Share the excel file please @manjesh_kumar

[manjesh_kumar]

Hello @NIVED_NAMBIAR Input.xlsx (9.9 KB)

[Marius_Puscasu]

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,
Marius

[manjesh_kumar]

Dear @Marius_Puscasu,

That works well and serves the purpose. Thank you.

@NIVED_NAMBIAR Thank you also for your efforts.

Regards,
Manjesh