Transposing in Excel without any extensions

Help Studio
, ,
1

Dear UiPath Developers,

I’m still learning UiPath and would seek your guidance on how to transpose from column to rows using workbook activities.

From this:
image

To This:
image

Thank you in advance!

2

Hi @Shawn11

Welcome to UiPath community

Check out the video link and thread

Regards
Gokul

1 Like
3

Hi @Shawn11

Checkout this method

Regards
Sudharsan

1 Like
4

Hi Sudharsan,

I’m unable to use modern excel activites the version im using is 2020.10.6.

Are there any other ways?

Thank you!

Regards,
Shawn

5

Hi Gokul, Thank you for your input, but seems abit too complicated for me… Doesnt seem to work as the headers are in a column.

6

@Shawn11

Please follow the steps

  1. Build the datatable with required 5 columns with names and name be newdt
  2. Use afor eqch row in datatable activity on original table dt
  3. Use a if condition with currentrow("Header").ToString.Equals("ID")
  4. On the then side use add data row and give array row as {} and datatable as newdt
  5. After the condition use assign activity newdt.Row(newdt.Rows.Count-1)(currentrow(“Header”).ToString) = currentrow("Value").ToString

Hope this helps

Cheers

7

Hi Anil,

May I check what should I include in the properties of Add data row?

Thank you!

8

@Shawn11

In array row field - {}
And in datatable field - newdt

Cheers

9

@Shawn11

The process can be easily replicated by following the instructions provided in the video or blog. It is straightforward and uncomplicated. Just try it

10

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