0

I've searched around a good amount and I have not found a solid answer for this question, despite a few promising looking question titles.

This question here for example: Drag down formula and change COLUMN references instead of ROWS

Unfortunately only works for specifically referenced cells. I'm working with a data set that is likely to have columns added to it in the future, and I need to pull the first row of these columns dynamically into a vertical list. Because of this, the method accepted as an answer in that question is not a solution for my problem.

I have data coming in like this:

Mock raw data

and I'm pulling the Course names into a vertical list like this:

mock list

The thing is, more courses are likely to be added in the future, and I'd like to be able to just drag down my formula to pull them.

SchrodingersStat
  • 291
  • 3
  • 19

1 Answers1

1

Try this formula in cell A10 of the first sheet in your question ...

=INDEX($1:$1048576,1,1+ROW(10:10)-10)

... and then drag it down!

The formula works by using the current ROW() number to calculate the required column number, which is passed into the INDEX() function.

3-14159265358979323846264
  • 3,250
  • 2
  • 15
  • 38