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.
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 there a way to automate the process of transposing all of this data into my desired format?