Forum Discussion
How to drag a cell reference formula down a column, but move the cell reference across a row
I am trying to drag a cell reference formula down a column, but have the row value increase as the formula is dragged down. For instance, in the shot below, cell B3 has the formula "=I3". I woul...
To make it dynamic, you might use:
=LET(rng,I3:ZZ3,nonblanks,COUNT(rng),dynamic,TAKE(rng,,nonblanks),TRANSPOSE(dynamic))
If it's a one-off, you could simply try:
=TRANSPOSE(I3:K3)
Fill handle not needed.