How to convert the row and the column in a datatable

[ChangShuang]

Hello Everyone,

Good day~~

I have a problem about the datatable

I want the convert the table from table1 to table2 like below.

does anyone know how to it?

Thanks for your help in advance.

[lakshman (Ganta lakshman)]

@ChangShuang

Please check below thread.

Transposing Excel Data Into a DataTable

Hi I’m incredibly new to RPA and am struggling to transpose data within my Excel spreadsheet. Unfortunately my set of data is not organised in the regular CSV/Table format. My column data is set out vertically with the next set of data directly below the first set. I will provide an example of how my data looks. [uipathforum] I’m able to transpose one set of data into the correct format using Excel, but attempting to transpose it all at once just recognizes all of my sets as new headers. Is …