Dear all, I would like to check if it is possible to transpose a datatable with Linq. Most guide shows from a tabular format (B) to (A) but not the other way round. Appreciate the community help and thank you in advance! Sample Data New Microsoft Excel Worksheet.xlsx (9.4 KB) A. Raw Data Row Number Sales Purchase Derivative Entrust Ship Sales 1 AOK CC B. Expected Result Row Number Commodity Value 1 Sales AOK 1 Purchase 1 Derivative 1 Entrust CC 1 Ship Sales Regards Hidayat

[image] Md_Hidayat: to transpose a datatable with Linq One of more options: Build DataTable Activity - dtResult, Configured 3 Columns: RowNumber, Commodity, Value Assign activity dtResult = (From d in dtDataOrigVar.AsEnumerable From i in Enumerable.Range(0, d.Table.Columns.Count).Skip(1) Let ra = new Object(){d(0), d.Table.Columns(i).ColumnName, d(i)} Select r = dtResult.Rows.Add(ra)).CopyToDataTable

Hi @Md_Hidayat Please check on this [image] How to Transpose Excel data or Data Table? Tutorials Hello UiPathans robot Here we discuss how to Transpose the data in Excel or a data table What is meant by Transpose? Input [image] Output point_down [image] Transpose can achieve by two methods → Modern activity- Using Copy/Paste range Activity.(For Excel Processing) → Novigo Solutions. (For Datatable Processing) Modern activity- Copy/Paste range Activity. By Using modern activity we can achieve the transpose method. For classic users can select Show Modern from the Activit… Hope this helps!!

TransPose DataTable

Help Studio

lrtetala (Lakshman Reddy) October 11, 2023, 9:48am 3

Hi @Md_Hidayat

Please check on this

Hope this helps!!

Topic		Replies	Views
Transpose data in DataTable Activities excel , orchestrator , activities , question , system	3	1426	November 2, 2022
How to transpose the datatable using linq Studio datatable , activities , system	3	2247	March 13, 2020
Transpose Activities excel , activities , studio , question	4	1280	October 15, 2022
Transpose execl using LINQ query Activities datatable , excel , selector , orchestrator , robot , activities , studio , data-scraping , error , string , data-manipulation , activities-panel	12	2313	June 11, 2021
Transpose - Excel Data using LINQ Studio datatable , excel , activities , studio , question , system , activities-panel , linq , linq-query , cast	6	1625	March 19, 2023

TransPose DataTable

Related topics