Help me!!

  • Thread starter Thread starter kumawat_s
  • Start date Start date
K

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
 
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
 
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())
 
Hello Dave. I'd be lying if I said I nearly posted
=OFFSET(Sheet1!$A$1,0,ROW()-1,1,1)
Click to expand...

as a follow-up.

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

Rgds,
Andy
 
Back
Top