Unpivot other columns

Dear All

Can someone please guide me on how to Unpivot other columns in UiPath Studio.

I have an excel sheet with multiple columns, which contain string & integer data. The integer data (green columns) has values for each day. I would like to select all these columns (of days) and unpivot to the available other columns of strings (blue columns).

I can do this in Power Query, but wanted to know, if this is possible in Studio.

Appreciate your guidance.



Anyone has an idea on how to do this please…

@Palaniyappan - can you please help me here !

I finally managed to get this working. Not a smooth solution, but able to automate the task, since my file has columns added dynamically.

I input the power query commands to do the job instead of multiple clicks.

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