Switching rows and columns

I have been sent a sheet from which I want to extract data row by row, but
the rows are currently the columns and vice versa.

Is there a way to switch the orientation of the worksheet?

Look at Paste Special, Transpose

--
Kind regards,

Niek Otten

"fairmeadow" <[email protected]> wrote in message news:[email protected]...
|I have been sent a sheet from which I want to extract data row by row, but
| the rows are currently the columns and vice versa.
|
| Is there a way to switch the orientation of the worksheet?
|
|