"Cross"-Auto filling: consecutive columns into rows

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

Jacob Skaria

=INDEX(Sheet1!$1:$1,ROW(A1))
and copy down..for getting the values from sheet1 row 1


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing two spreadsheets part 2 10
Vlookup based on two lookup values 2
Nameing a function 1
More on SumProduct 1
AdvanceFilter Problem 2
Count Consecutive string of same number 6
How to count the maximum number of consecutives? 9
How can I do this? 7

Top