How to transpose columns to rows in datatable?

[hsendel]

Dears,

I want the inverse process of the following :

How to transpose row to column in datatable?

Means :

From :

To :

Note : For my case I have many rows not only one
Thanks in Advance

[hk803592 (hemant)]

Hi,
Have you tried searching for same question in forum, i think there is a post on the same.

So i think the only solution to your problem is to iterate through you data table using for each row activity and create your new table from that.

[hsendel]

Thanks

I search but didn’t find exact solution for my case , all foudn case are rows to columns, here’s my example :

[hsendel]

I find DataManipulation Package but I don’t know how to set the inputs

[hk803592 (hemant)]

In this case use
Build data table activity, add 2 columns
Then inside for each row use in ur original data table
4 Add rows

Like
add row(‘firstname’ ,row.item[0])
add row(‘lastname’ ,row.item[1])
add row(‘address’ ,row.item[2])
add row(‘mobile’ ,row.item[3])

Then write this datatable to excel uaing write range

[hsendel]

Thanks, I will check and let you know…

[hsendel]

not clear can you please explain more, in my for each activity, it’s stating the rows but for my case need to state columns!!!

[Lahiru.Fernando]

Hello @hsendel

In the activity set the input as below

RPA Components - Bundles, Integration Packs | UiPath Marketplace

You’ll also find the guide under resources…

[hsendel]

Thanks Lahiru.Fernando
I use it but I got the following :

My Needed Output is :

[Palaniyappan (Forum Leader)]

here you go with a xaml
hope this would help you
transpose.zip (17.4 KB)

Cheers @hsendel

[hsendel]

Excellent!!! Palaniyappan.Thanks Lahiru.Fernando too for your support.

[hsendel]

Another query, How to deal with Build Data Table of number of rows is not fix ( Changing) ?

[Palaniyappan (Forum Leader)]

Usually here we will having only two columns right
left is column name and right is value of the column, so two in total

Cheers @hsendel

[hsendel]

YES YES Correct !!!