Transpose Datable

[Kuldeep_Pandey]

Hey Team
I want to Transpose row data in column data in excel
Birthday.xlsx (8.6 KB)
Please Help or provide me xml file for this

[Nishant_Banka1 (Nishant Banka)]

Please refer this

How to transpose row to column in datatable?

Hello @saintseiyer I have recently published an UiPath activity pack which includes a data transpose activity. You can easily get your data transposed as you need using this single activity. https://go.uipath.com/component/data-manipulations# Make sure to go through the activity guide document on how it can be configured…

[sathya_auto]

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

[Kuldeep_Pandey]

Please provide me xml

[Gokul_Jayakumar (Gokul Jai)]

Hello @Kuldeep_Pandey
Refer to this thread, you will get an idea

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…

[Gokul_Jayakumar (Gokul Jai)]

@Kuldeep_Pandey
Refer to this Xaml file you may get some idea.
Forum_Transpose.zip (148.2 KB)