Unpivot other columns

[AVipani (AV)]

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.

Regards

[AVipani (AV)]

Hi,

Anyone has an idea on how to do this please…

@Palaniyappan - can you please help me here !

[AVipani (AV)]

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.