Transposing Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dj_money - 12 Aug 2006 01:42 GMT

I got Two workbooks I'm working with. One is _Destination_ and th
other will be the _Source_ Workbook.

In the _Source_Workbook_, this is what I have:

... A .. B
1: Ran 30
2: Ran 20
3: Ran 10

I want to link this source workbook to m
_Destination_Workbook_ so that it would displa
this:

.... A . B . C.. D
1: RAN 30 20 10

Anyone knows the function for this? I'm not sure if it's transpose()
Index(), column().... I don't know. I tried it all and I it won't ru
the way i want it. Please Help..

Reply to this Message

RagDyer - 12 Aug 2006 02:38 GMT

The logic of:
A1 - B1 - B2 - B3
escapes me.

Would you care to explain it to a "not overly bright old man" like me?

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>
> I got Two workbooks I'm working with. One is _Destination_ and the
[quoted text clipped - 17 lines]
> Index(), column().... I don't know. I tried it all and I it won't run
> the way i want it. Please Help...

Reply to this Message

dj_money - 12 Aug 2006 03:16 GMT

Ok.. That's what I wanted. A1 - B1 - B2 - B3.

That tells me that the cells in Column A is just "Ran" but how man
minutes did he ran within the attempts in B1 to B2 to B3.

So it would be "Ran - 30 - 20 - 10" Now I'm not sure if that'
transposing or what not. But i have a feeling that it has to b
involve with Index() or match() or vlookup(). I'm not sure how to pu
these functions together

Reply to this Message

paul - 12 Aug 2006 08:30 GMT

in your destination work book you have RAN in a1 and across b1 c1 d1 you
enter the formula =transpose(source!B1:b3) and when you are ready hold contrl
and shift down then press enter

Signature

paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!

> Ok.. That's what I wanted. A1 - B1 - B2 - B3.
>
[quoted text clipped - 5 lines]
> involve with Index() or match() or vlookup(). I'm not sure how to put
> these functions together.

Reply to this Message