This is a little complex, so I'm not sure how it'd be done, but here goes:

I have a list of election results for the British election in 2010 which I'm trying to compile into a format like this:

\1

The list of base data I have however has each constituency in columns rather than in rows:

\1

I know there's the copy and paste using the Transpose tool, but I don't really want to have to do this 650 times for each individual constituency: is there any way I can select all of it and do some kind of trick so that it knows when to go to a new row based on when the name of the constituency changes?

Thank you!