How to transpose row to column in datatable?

Hi, I have an example datatable here.
190704%2015_03_16

I want to change row to column. It looks like here.
190704%2015_03_24
How can I do this?

2 Likes

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

2 Likes

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)

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… :slight_smile:

7 Likes

Dears, I want the inverse , Possible?

Use the same activity I mentioned above… :slight_smile:

Thanks Lahiru.Fernando

Her’s my Input and Target Output :

Thanks in Advance

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

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.