[mso] Re: Excel (Office) - transposing ranges
- From: "Ray Blake" <ray@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 30 Jul 2004 06:39:18 +0100
One way to do this would be to use the 'transpose' feature in the
Paste-Special dialogue. Use the fill handle to fill in the same manner
as the source sheet, then select the range in your destination sheet,
cut it, then from Paste-Special perform a transpose paste.
Ray
------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
www.grbps.com
------------------------------------
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of beaton5284
Sent: 30 July 2004 05:54
To: mso
Subject: [mso] Excel (Office)
Using Excel 2002 and XP.
Not sure how to pose this question. Has to do with one sheet
referencing data from another sheet. My problem is that the sheet that I
am importing data to is arranged on a row basis, i.e., c4,c5,c6 etc.
The data is coming from a sheet arranged on a column basis, i.e.,
b4,b5,b6 etc.
I would like to use the fill handle, on the receiving sheet, if
possible. Otherwise it means referencing or copying each item of data
as I go along. (It would be very inconvenient to rearrange the two
sheets in the same format.) bille
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
- » [mso] Re: Excel (Office) - transposing ranges
