Transpose data in DataTable

[guptasweb]

I want to transpose the data,this is my input file

In the output file,I want to add one column i.e Plant Name which is supposed to be sheet name.How to do it with the help of linq query.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @guptasweb,

Please find the below-attached link.

How to transpose row to column in datatable?

Hi, I have an example datatable here. [190704%2015_03_16] I want to change row to column. It looks like here. [190704%2015_03_24] How can I do this?

[Tapan_Behera1 (Tapan Behera)]

Hi @guptasweb follow this video and use that linq to transpose your data table

UiPath | Transpose DataTable using LINQ query | Transpose Collection | Convert Table to Dictionary

[guptasweb]

its not working.when i open the link below screen is visible