transform data in excel

V

Vincent Yang

I need to transform data in an excel srpeadsheet. I need to reverse a
5 rows, 200 columns table into a 5 columns, 200 rows table.

Much appreciated!Vincent
 
R

Roger Govier

Hi Vincent

Copy the set of data.
Got to your destination and choose Paste Special and click the box marked
Transpose.
 
Top