Currently i’m developing RPA with extraction data from excel/pdf with following data :
From above data, i need to do some massaging data to :
- Rename Column Name with new name based on their increment column name.
ex : column 10,5,20,10,5 will be rename become 10,15,35,45,50 (10+5=15, 15+20=35 and so on)
- Separate on new datatable based on column 10-50 that has data (remove column with blank data
Expected output :
I don’t know hot to do this, can we achieve this using VBA macro/UiPath Studio?