Hey Guys I am trying to work out how to transpose some data the first spreadsheet is the data.
I need it to look like this below
Where the columns E to N make the rows down and then I need the data from columns A and B to be on the corresponding rows of data. Leaving out the blanks.
Cheers
I need it to look like this below
Where the columns E to N make the rows down and then I need the data from columns A and B to be on the corresponding rows of data. Leaving out the blanks.
Cheers