i am doing artist royalty statements. it's boring.

anyway, the spreadsheet is set up so the (small) list of bands is vertically down the first column, and the payments by month are horizontally along the top.

it makes more sense to have them the other way round.

is there an easy way or switching them round or am i going to have a tedious cut and paste job on my hands?