Pivot data?

[fairymemay (noona)]

I have input as below.

I want output as below

My file as attached.
pivot data.xlsx (21.5 KB)

Please guide me about it.

[fairymemay (noona)]

Any​idea for​ solve​ this​ case?

[ridvanucok]

Hi @fairymemay ,

This video can help you with using the pivot table.

UiPath Tutorial || Day 40 : Create Pivot Table and Refresh Pivot Table

[fairymemay (noona)]

Can share demo flow to me please?

[ridvanucok]

Hi, @fairymemay
By watching the activities in the video, you can create a flow as in the image below.