Copy data

[amaresan (Amaran)]

@sshitol

For Transpose row to column

Refer below post … it may help you

Transposing Excel Data Into a DataTable

Hi, use ReadRange activity in cycle and in each loop read one data set (ID,name, day, month) into a temp datatable calculate “range” dynamically, e.g. varRange = “A” + cstr(row) + “:B” + cstr(row+3) in each loop increment row by 4 to move to next data set, e.g. row = row + 4 append individual data sets from temp datatable to final datatable finish loop when reach end - temp datatable is empty Intentionally do not post complete workflow here as it would not help you to grow Cheers