Swapping rows for columns and columns for rows in a large database

Hello,

I have a database from a survey and I would like to swap the way it was set up. The attached file shows the format, but the columns of current data will go on much further in the original. Basically I want what is in column A to go across the top in a row (the survey questions), and beneath it what was in column B to go across like a row (the survey answers). Basically flipping the set up of the survey. When I tried to do copy/paste special/transpose it would not work (error message that cells were no the same size). Is there a macro that can fix this or a simpler solution?

Kind regards