Columns into Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CherylCS@officeformac.com - 17 Jul 2008 18:13 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm importing data by cutting and pasting from a database, but when I paste it fills down rather than across. I need my data to go across rows so that I can export it to a database program. Is there a way to "flip" the spreadsheet?

Reply to this Message

Bob Greenblatt - 17 Jul 2008 18:22 GMT

On 7/17/08 1:13 PM, in article 59b5473d.-1@webcrossing.caR9absDaxw,

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 3 lines]
> fills down rather than across. I need my data to go across rows so that I can
> export it to a database program. Is there a way to "flip" the spreadsheet?

After you select the cell in Excel where you want the data to begin, DO NOT
use Paste. Instead, go to the Edit menu, select Paste special and select
transpose.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / July 2008

Columns into Rows