Can he not just use the TRANSPOSE function instead of OFFSET?
=TRANSPOSE(Sheet1!A1:BX50) as an array formula?
--
David Biddulph

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Another option: you can transpose on a second sheet like this.

Assume the upper left corner of your table is at B1 (so it is in column
#2,
row #1 you need to remember that)

on a second sheet pick a location to be the upper left corner, can even be
same as in the original sheet, put a formula similar to this:
=OFFSET('Sheet1'!$B$1,Column()-2,Row()-1)
Notice the use of -2 and -1

You can now fill this formula across and down to get the values from the
original sheet. If you want you can now select the entire area and use
Edit
| Copy followed immediately with Edit | Paste Special with the "Values"
options chosen to make the changes 'permanent', i.e. turn them into values
instead of formulas.

"msn" wrote:

I am trying to transpose a bunch of data with 50 variables going down a
column and 75 variables running across the top in a row. When I try it
says
that my cells are of different sizes and so I can not transpose it all at
once. I have tried transpose 1 row at a time. At this time, I am asked
to
update values for, I'm pretty sure, every value. It does not retain all
and
some cells have REF#.
Does anyone have any suggestions?