I have sorted excel by date row in excel how do I add below values of the date in datatabledata-WPS Office.xls (11 KB) .if I sort the date the below value of the date should also sorted below the correct date
Can u share of how u need the output?
data-WPS Office.xls (11 KB) the output should be sorted in ascenting order.here I have mention only 3 rows but it will have many rows with data
I think u can try this approach
Read the excel file strting from cell A3.
Now transpose that table so that Date, period and text become column
now u can use sort datatable activity to sort the datatable
Now transpose it again and thus it beomes in original mode with being sorted and then write to the excel starting with cell B4
(i think for transposing there is activity in uipath )
Hope you got the logic,
Can you explain me with code
Check this workflow
For transposing the datatable i had used the below activity
sample workflow.zip (4.0 MB)
Mark it as solution if it resolves ur query