Is it possible to copy one worksheet into a new one but switch the headings
to be on the left vertical and vice versa? Or must I manually recreate the
whole worksheet in this new set-up?

Thanks