How to copy row values to respective columns

This is my input
INPUT

Expected OutPut

DATA.xlsx (8.6 KB)

@adarsh_kotagiri

Download DataTable package from UiPath Market place and install it in UiPath studio. And then use Transpose DataTable activity to convert rows into columns.

1 Like

If not marketplace activity, Use For each for the data the you get after reading your input

Split using “,” then this will give you an array, add that array as a datarow using Add Datarow

1 Like