"Cross"-Auto filling: consecutive columns into rows

  • Thread starter Thread starter AndreasW
  • Start date Start date
A

AndreasW

How can I auto fill a column with a formula referencing to consecutive
columns in another sheet?
Example:
A
1 =OtherSheet!A1
2 =OtherSheet!B1
3 =OtherSheet!C1
....
 
=INDEX(Sheet1!$1:$1,ROW(A1))
and copy down..for getting the values from sheet1 row 1


If this post helps click Yes
 
Back
Top