I created a bot that loops through a list of ticker symbols on an excel spreadsheet, types them into Morningstar and grab the quarterly results of the previous year. This appears to work as planned. However the way the data is set up on the website doesn’t match my excel file layout.
For example: My excel sheet looks like
Ticker Name Q1 Q2 Q3 Q4
However the set up of the web table cause the input to be placed:
Q 4 data
Therefore the Q1 is next to ticker 1 and Q2 (for ticker 1) is next to ticker 2
Is there anyway to Transpose(such as the paste special type in excel) this data so that it goes across the row instead of down the column?