How to convert the row and the column in a datatable

[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 …