I would be really grateful for any advice on a data (datatable) manipulation process. As part of an automation process I would like to - “unpivot” / melt a number of columns into one column.
This is very easily done in ‘R’ using the pivot_longer() (formerly gather()) functions and in Pandas the melt() function. I have already run this process in R and Python and understand that this code can be used by UiPath but my superior wants everything to be done in UIPath.
This can be done using power query in excel to “unpivot” - so I was hoping with UiPath’s excel integration I could do the same?