From Column to Row

K

Ken Wright

Select A1:AT1 in Sheet 2, type =TRANSPOSE( then select A1:A50 on sheet1, put in
the closing parenthesis and then hit CTRL+SHIFT+ENTER to array enter it.
 
H

Hari

Hi,

I have some data in a column. I want to copy the same row wise such that
link to the original column data is maintained.

That is if I have data from A1 to A50 ( of worksheet 1 ) I want the same in
A1 to AT1 ( of worksheet 2 ) such that cells in worksheet 2 is linked to
cells in worksheet 1

Regards,
Hari
India
 
T

Trevor Shuttleworth

Hari

put the formula: =INDIRECT("Sheet1!A" &COLUMN()) in cell A1 on Sheet 2
and drag across to AT1

Regards

Trevor
 
S

Soo Cheon Jheong

Hari,

Enter this formula in A1 (of worksheet 2) :

=INDIRECT("Sheet1!A"&COLUMN(A1))

or

=INDEX(Sheet1!$A$1:$A$50,COLUMN(A1))

or

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


then drag and fill right to AT1


--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--
 
Top