ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   flip spreadsheet data from row records to column record fields (https://www.excelbanter.com/excel-discussion-misc-queries/28191-re-flip-spreadsheet-data-row-records-column-record-fields.html)

Peo Sjoblom

flip spreadsheet data from row records to column record fields
 
Select the table, copy it, insert a new sheet and do editpaste special and
select transpose

Regards,

Peo Sjoblom

"Wasan" wrote:

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?




All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com