View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

If you have less than 256 rows, copy the data, go to a new sheet and do
editpaste special and select transpose
If you have more than 256 rows it can't be done, then you need to put it on
multiple sheets since excel only have 256 columns



--

Regards,

Peo Sjoblom

"Larry Heine" <Larry wrote in message
...
I been building a spreadsheet to record data and would like to interchange
the rows and columns to make viewing easier (I want to make the row data
become column data and the column data become row data).

Thanks!