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!

@Shawn11 Please follow the steps Build the datatable with required 5 columns with names and name be newdt Use afor eqch row in datatable activity on original table dt Use a if condition with currentrow("Header").ToString.Equals("ID") On the then side use add data row and give array row as {} a…

Transposing in Excel without any extensions

Help Studio

Sudharsan_Ka (Sudharsan Ka) June 6, 2023, 12:00pm 3

Hi @Shawn11

Checkout this method

Regards
Sudharsan

1 Like

Topic		Replies	Views
Transpose the excel sheet data Studio activities , studio	7	1231	August 26, 2022
How to transpose column to row in data table? Studio studio , question , activities_panel	4	5126	November 5, 2022
How to transpose first row to column view in excel Activities excel , activities , studio	14	1000	September 22, 2023
How to move row items to column(Transpose) in excel using UiPath Activities excel , activities , workflow , question	5	5247	July 9, 2021
Transpose Activities excel , activities , studio , question	4	1177	October 15, 2022

Transposing in Excel without any extensions

Related topics