Only by exporting to excel and using feature in excel to swap rows for columns can you get the result you want
