Talk About Network

Google





Mac > Excel Office for Mac > Re: turn spread...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 3 Topic 5621 of 6965
Post > Topic >>

Re: turn spreadsheet row into a column

by JE McGimpsey <jemcgimpsey@[EMAIL PROTECTED] > May 15, 2008 at 11:14 AM

In article <ee9b274.-1@[EMAIL PROTECTED]
>,
 Tiger_MO@[EMAIL PROTECTED]
 wrote:

> Version: 2008
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: intel
> 
> I have im****ted data into Excel that creates a row of data. I would
prefer 
> that the data be in a column instead of a row. How can I turn a row into
a 
> column.? I can't use PivotTable because I have only one row and
cut/paste 
> doesn't do it either.

One way:

Copy the row. Select the cell to start at in the column. Choose 
Edit/Paste Special, and check the Transpose checkbox.
 




 3 Posts in Topic:
turn spreadsheet row into a column
Tiger_MO@[EMAIL PROTECTED  2008-05-12 09:18:40 
Re: turn spreadsheet row into a column
JE McGimpsey <jemcgimp  2008-05-15 11:14:19 
Re: turn spreadsheet row into a column
Tiger_MO@[EMAIL PROTECTED  2008-05-15 10:06:39 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 2:16:43 PST 2009.