Flipping the chart

Eric · Sep 22, 2003

Is there an easy way to flop columns and rows? Meaning, I
want to make row 1 be column 1, row 2 to column 2, etc.

Thanks!

Andy B · Sep 22, 2003

Eric

Try using Copy and then Paste/Special/Transpose.

Andy.

dvt · Sep 23, 2003

Eric said:
Is there an easy way to flop columns and rows? Meaning, I
want to make row 1 be column 1, row 2 to column 2, etc.

Thanks!

Select the area to be flipped, Edit | Cut, Paste Special | Transpose. Or
use the TRANSPOSE function.

Dave
dvt at psu dot edu