Transposing Cells

D

dj_money

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..
 
R

RagDyer

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

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

dj_money

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
 
P

paul

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
 
Top