Transpose data in DataTable

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.
image

Hi @guptasweb,

Please find the below-attached link.

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

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