Help me!!

[kumawat_s]

I have data columnwise in A1, B1, C1, .............Z1


I want to link these data in different sheet in C coloumn. I link C1 t
A1 but when I copied C1 and paste in c2 the value of B1 does no
appears. Because in formula row no increases (a2, a3, a4......) and
want it columwise like a1, b1, c1.......


What would be procedure/function.

S kara

 

[Andy Brown]

What would be procedure/function.

Difficult to say if it would be appropriate, but you could try TRANSPOSE.

Select C1:C3 on the different sheet. Type

=transpose(Sheet1!A1:C1)

, press CTRL+Shift+Enter.

Obviously you'll need to use the name of your own original sheet.

HTH,
Andy

 

[JJ]

Give me an example of what you have and what you want, I
do not understand your problem.

 

[Dave Peterson]

A formula like:
=OFFSET(Sheet1!$A$1,0,ROW()-1,1,1)
might do what you want.

I like this one, too:
=INDEX(Sheet1!$A$1:$Z$1,1,ROW())

 

[Andy Brown]

Hello Dave. I'd be lying if I said I nearly posted

=OFFSET(Sheet1!$A$1,0,ROW()-1,1,1)

as a follow-up.

I nearly posted =OFFSET(Sheet1!$A$1,0,ROW()-1) as a follow-up.

Rgds,
Andy