I have a datatable in which the values in second column needs to be header in the transposed dt and the values from 3rd column onwards needs to be datarow in the transposed dt

@SunnyJha You can follow the steps Delete the first column as you dont need usign delete data row Now use generate datatable activity and pass the string as String.Join(",",dt.AsEnumerable.Select(function(x) x(0).ToString)) and select comma as row separator and check the header box Delete the col…

How to transpose datatable?

Help Studio

aravindbalineni123 (Aravind Balineni) May 18, 2024, 7:45pm 2

Hi Sunny,

Please use these methods to transponse datatable in UiPath:

Let me know if it doesn’t work as expected.

Topic		Replies	Views
Transpose the datatable Studio studio , question , activities_panel	8	195	June 13, 2024
Transpose Datable Robot robot , question	5	1947	March 24, 2023
How to transpose column to row in data table? Studio studio , question , activities_panel	4	5395	November 5, 2022
Transposing in Excel without any extensions Studio studio , question , activities_panel	9	578	June 7, 2023
How to convert required columns in to rows Studio datatable , excel , studio , question , linq	8	490	February 24, 2024

How to transpose datatable?

Related topics