Switch

[cal1]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel How do I go about interchanging rows and columns. I need to do this in order to produce some meaningful charts.
Cal1

 

[Jim Gordon Mac MVP]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel How do I go about interchanging rows and columns. I need to do
this in order to produce some meaningful charts.
Cal1

Hi,

Select the data range.
Copy the data (Edit > Copy)
Click into an empty cell where you want the data to be pasted
Use Edit > Paste Special and click the the Transpose button.

-Jim

 

[cal1]

It worked, and thanks a lot. Good to ged a reply from a distinguished MVP!
cal1