Hi, Could you teach me if I need to convert my excel table from Horizontal to Vertical. What Activities suitable for my issue? (Incase my data over 100 rows.) [image] Thanks! *remark: it’s ok if result of vertical data without ColumnA ( ID01,NAME01,DEPT01,POSITION01,ID02 …)

Hi @Hyde , You can do it in c# with the code available in this link, use invoke code activity from your workflow and try it. [JohnNate] How to transpose a datatable to get the second datatable in C#? c# asked by JohnNate on 06:24PM - 06 May 20 UTC …

Thanks I will try to understand it. But it’s very difficult for beginner. :joy:

@Hyde Please try this Build a datatable with two columns and of string type and name as newdt Use for each row in datatable and loop original table dt Use another for each activity inside with in argument as dt.Columns and change type argument yo column( in new activity type argument is auto co…

Hi @Hyde Try this- Use the “Read Range” activity to read the horizontal table from the Excel file. Specify the range of cells that contain the table. Store the output in a variable, let’s call it dtHorizontal, of type DataTable. Create a new empty DataTable variable, let’s call it dtVertical,…

Thanks for your help, But my UiPath Studio Community don’t have activity “For Each Column” Do I need to update or do something ? Thanks !

Thanks, I’ trying your solution. but I stuck on ArrayRow (Code Error) [image] Can I give column name from original in excel file ? Do you have advice me. Thank you !

[image] Anil_G: {currentitem.ColumnName + currentRow(0).ToString,currentrow(currentitem.ColumnName).Tostring} @Hyde This should be the array row value In place of zero you can give the id column name …other columns are automatic depending on which column it is cusing currentitem.columnname …

Convert Excel table <Horizontal to Vertical>?

Help Community

sarathi125 (Parthasarathi) June 5, 2023, 7:42am 2

Hi @Hyde,

You can do it in c# with the code available in this link, use invoke code activity from your workflow and try it.

Check this post as well:

Topic		Replies	Views
Change Horizontal Data to Vertical in same excel continously Excel TRANSPOSE Function Off-Topic Discussions	2	2221	July 24, 2020
Transpose Activities excel , activities , studio , question	4	1228	October 15, 2022
Transpose Datable Robot robot , question	5	1971	March 24, 2023
Transpose the excel sheet data Studio activities , studio	7	1300	August 26, 2022
How to convert horizontal excel data to vertical excel data individually Activities datatable , excel , activities , question	3	2344	November 18, 2020

Convert Excel table <Horizontal to Vertical>?

Related topics