Change order when pulling cells horizontally or vertically

[Jyggalag]

Hey guys,

I currently have a large list of data, but to simplify, here's a simple example:

I currently wrote cell C5 as = J5

I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5

However, I want it to full out A, B, C, D and E when i pull it down.

Is there any way to do this without changing the order of the original cells (column J-O)?

Thank you guys!!

Best regards,
Jyggalag

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3
4
5			1							1	A	B	C	D	E
6			A							2
7			B							3
8			C							4
9			D
10			E
11
Main

Cell Formulas
Range	Formula
C5:C10	C5	=INDEX($J$5:$O$5,ROWS(C$5:C5))

 

[Jyggalag]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3
4
5			1							1	A	B	C	D	E
6			A							2
7			B							3
8			C							4
9			D
10			E
11
Main

Cell Formulas
Range	Formula
C5:C10	C5	=INDEX($J$5:$O$5,ROWS(C$5:C5))

Thank you Fluff! It worked.

Saved my day, as always Hope you had a good Easter!

Kind regards,
Jyggalag

 

[Fluff]

You're welcome & thanks for the feedback.