Well, it's a lot quicker to do it all at once !!

Pete

On Apr 17, 12:18*pm, wrote:
On Wed, 16 Apr 2008 17:04:58 -0700 (PDT), Pete_UK
brought the following to our attention:

Highlight all the data, then click <copy. Move your cursor to a cell
outside the range occupied by the current data (eg to row 74) and
click on Edit | Paste Special | Transpose (check) | OK then <Esc.

If you are happy that you have ended up with what you wanted, then you
can delete the original 73 rows.

Hope this helps.

Pete

Thanks for that.. I've been transposing single columns into rows but
haven't tried a WHOLE block of data. Will test it out this morning.

* -G



On Apr 17, 12:57*am, wrote:
I have a 400 column by 72 row array of data that needs to
be transposed into 72 col x 400 rows. What's the best way
of accomplish this? Best would be to do it one-shot.

* *-G- Hide quoted text -

- Show quoted text -