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?