How to group rows and transpose them to columns

[Arunachalam]

@smaherzi

Can you please check this link. This could help you a lot for your question.

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 …

Thanks,
Arunachalam.