Making a Verticle List Horizontal

[SamuelT]

Hi all,

I have a long list of projects going from A2:A231. In another worksheet I'm trying to display the same list horizontally, ie: A2 through to (and I'm guessing here) GA2.

Is there a means/formula that allows me to do this? I've tried simply dragging the cells, as I would if I was copying the verticle list, but it copies the same horizontal cells.

Can anyone suggest what I could do to rectify the situation?

TIA,

SamuelT

[Dave Peterson]

You can
select your range
edit|copy
select A2 of the second sheet
edit|paste special|check transpose.

Or you could use a formula:

Select A2:GA2 (same guess as you!)
type this:
=transpose(sheet1!a2:a230)
and hit ctrl-shift-enter

Now if you change the first range (A2:A230), the second range (A2:GA2) will
change--'cause it's a formula.

SamuelT wrote:
>
> Hi all,
>
> I have a long list of projects going from A2:A231. In another worksheet
> I'm trying to display the same list horizontally, ie: A2 through to (and
> I'm guessing here) GA2.
>
> Is there a means/formula that allows me to do this? I've tried simply
> dragging the cells, as I would if I was copying the verticle list, but
> it copies the same horizontal cells.
>
> Can anyone suggest what I could do to rectify the situation?
>
> TIA,
>
> SamuelT
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=512230

--

Dave Peterson

[SamuelT]

Many thanks Dave. The 'Paste Special' works great (oh, it's actually HW2!)

[Rajah]

SamuelT wrote:
> Hi all,
>
> I have a long list of projects going from A2:A231. In another worksheet
> I'm trying to display the same list horizontally, ie: A2 through to (and
> I'm guessing here) GA2.
>
> Is there a means/formula that allows me to do this? I've tried simply
> dragging the cells, as I would if I was copying the verticle list, but
> it copies the same horizontal cells.
>

Samuel,
An easy way to do this is to:
1. Select cells a2:a231
2. Edit -> Copy the cells.
3. Move to A1 (or some other cell that doesn't overlap A2:a231)
4. Edit -> Paste Special. (Not the regular Paste here.)
5. Check the transpose box.
6. Press the OK button.

That should do the trick.