How to move row items to column(Transpose) in excel using UiPath

Hey Rajesh,

here is an easy way to transpose row values to columns.

Assuming you already have a datatable (lets call it dt_source) with one column of relevant values, which you want to transpose to columns.

  1. Initialize a new empty datatable (for transposed values, lets call it dt_target)
  2. Iterate through dt_source with a For Each Row activity
  3. Inside the For Each Row Body insert an Add Data Column activity
  4. Fill the properties with the target datatable (dt_target) and the ColumnName (that would be the row(“value”) to be transposed)
  5. That’s it, you’re done. Write Range (dt_target) to Excel to inspect your results.

Happy automating

1 Like