How to transpose row to column in datatable?

[saintseiyer]

Hi, I have an example datatable here.

I want to change row to column. It looks like here.

How can I do this?

[kalyanDev]

First read the data store it separate variable like No = datatable[0][Column2]
Sex = datatable[1][Column2] like that for all then
Create one datatable with the format that you want like No Sex Name Birthday then add one row this the above values

[vickydas (vicky)]

hello @saintseiyer
You can add all values in a list and than use add data row activity to add in a table please check the below workflow for better understanding
Coltorows.xaml (16.4 KB)

[Lahiru.Fernando]

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…

[hsendel]

Dears, I want the inverse , Possible?

[Lahiru.Fernando]

Use the same activity I mentioned above…

[hsendel]

Thanks Lahiru.Fernando

Her’s my Input and Target Output :

Thanks in Advance

[kumarD (Mitradev Das)]

Hi @Lahiru.Fernando
I used your activity for data transpose and its perfectly working. Because of this activity my workflow is looks simple, Thank you very much and keep it up…

Thanks