flip spreadsheet data from row records to column record fields

[Wasan]

I have my spreadsheet with rows as records and columns as fields

I want to change it so that the data is flipped so that the columns are
records and
the rows are fields.

What is the easiest way to do this?

 

[Wasan]

Thank you!

Select the table, copy it, insert a new sheet and do edit>paste special and
select transpose

Regards,

Peo Sjoblom