How to transpose first row to column view in excel

Hi team ,
I have data in excel with single line row with multiple data so I need to transpose entire row in to “A”column . Please suggest any simple idea to achieve this . I tried multiple option which is giving in our community. But no luck .



Have a view on this

Hope this helps

Cheers @Krishnakumar_Vasudevan

Hello @Krishnakumar_Vasudevan
Try Excel Modern Activity

In Source, You can add the specific Range.

We do understand:

V1 V2 V3 V4

is to bring into this format:


We would do e.g.

  • Read range - unticked AddHeaders - dtData
  • Build DataTable - configure 1 column - dtResult
  • For each Activity | item in dtData.Rows(0).ItemArray | TypeArgument: object
    • Add Data Row Activity | DataTable=dtResult, ArrayRow= new Object(){item}

Hi @Krishnakumar_Vasudevan ,





Array row getting compiler error like identifier expected

If I gave value like. new.Object.{item} .

Please advice .

pay attention at the not needed dots

new Object(){item}

Thanks That error gone but getting error on add data row activity while executing.

Add row row .cannot set column ‘column1’ the value violates the max length limit of this column .

maybe better you will reread the above description ( do not mix up several mentioned variations)

Modelling could look like this:


Build DataTable - dtResult

Add DataRow:

Will do:

Hi @Krishnakumar_Vasudevan ,
transcope.xaml (13.9 KB)
You can try it

We can handle by:

Thanks Peter transpose worked . I want to write output in same excel to another sheet so I kept append range inside for loop each and data is getting duplicated .

Lets try to scope the topic = 1 case
So in DataTable the transponation is working, right

We can check with
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

So we would recommend to close the topic
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

we are surprised about the for each loop. Maybe you will create a separate topic for it.

In case you feel that this question is still in scope with this origin topic then please share with us some similar sample input data and expected output. Feel free to share also your XAML with us

I found the issue now and fixed it . It’s really helpful thanks pete …!!