Tricky Fill Series ...

[YesConsulting]

if you have a series of cells in a column spaning rows
and want to link to them, but transpose them into a single row spaning columns

I entered the first two hoping to create a fill pattern of the cell ref going down...
As can see from the image, when dragging the fill it goes back to the same orientation.

Question: How to have the fill series use the relative cell ref if the horz/vertical orientation is different from the source?

 

[Marcelo Branco]

Try

Y18
=INDEX($X$18:$X$22,COLUMNS($Y18:Y18))
drag to right

M.

 

[Fluff]

How about

+Fluff.xlsm
	X	Y	Z	AA
18	1	1	2	3
19	2
20	3
21	4
22	5
23	6
Main

Cell Formulas
Range	Formula
Y18:AA18	Y18	=INDEX($X$18:$X$50,COLUMNS($Y$18:Y$18))