Transpose excel data

[supriya117 (Supriya Allada)]

Hi @suraj.l

Check this:

How to Transpose Excel data or Data Table?

Hello UiPathans Here we discuss how to Transpose the data in Excel or a data table What is meant by Transpose? Input [image] Output [image] Transpose can achieve by two methods → Modern activity- Using Copy/Paste range Activity.(For Excel Processing) → Novigo Solutions. (For Datatable Processing) Modern activity- Copy/Paste range Activity. By Using modern activity we can achieve the transpose method. For classic users can select Show Modern from the Activit…

or

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. Initialize a new empty datatable (for transposed values, lets call it dt_target) Iterate through dt_source with a For Each Row activity Inside the For Each Row Body insert an Add Data Column activity Fill the properties with the target datatable (dt_target) and the ColumnName (that would …