Hi,

I have been sent data in the wrong format. The rows should be the columns. Is there a quick way of swapping this round. I need all the data in column A to become the column headers and the data in the rest of the sheet to follow this pattern.

Thanks