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.