Horizontal to Vertical

[johnny52]

=IFERROR(INDEX(A$1:C$9,CEILING(ROWS(E$1:E1)/3,1)*4-3,MOD(ROWS(E$1:E1)+2,3)+1),"")

This formula covers three columns (a1,b1,c1)converted to appear vertically e1,e2,e3......works great

how would I modify this to cover 4,5,6, columns of data etc (A$1:G$9)

 

[hnsd24_CN]

test.xlsm
	A	B	C	D	E	F	G	H	I
1	20	14	15	18	8	9	20	14	15
2	19	20	15	14	13	16	18	8	9
3	13	11	10	16	10	19	19	20	15
4	19	17	11	18	12	17	14	13	16
5	15	11	10	19	18	13	13	11	10
6	14	16	11	6	13	12	16	10	19
7	9	6	6	19	16	10	19	17	11
8	20	18	19	8	11	14	18	12	17
9	12	11	19	8	10	7	15	11	10
10							19	18	13
11							14	16	11
12		m		n			6	13	12
13		6 columns	to	3 columns			9	6	6
14							19	16	10
15	in this function,3=n,2=m/n						20	18	19
16							8	11	14
17							12	11	19
18							8	10	7
Data Import

Cell Formulas
Range	Formula
G1:I18	G1	=INDEX($A$1:$F$9,INT((ROW(A1)-1))/2+1,MOD(ROW(A2),2)*3+COLUMN(A1))

 

[johnny52]

Hi I wanted column g to read a1 to f1 vertically down

I just want my formula below to extend out a few more columns

=IFERROR(INDEX(A$1:C$9,CEILING(ROWS(E$1:E1)/3,1)*4-3,MOD(ROWS(E$1:E1)+2,3)+1),"")

 

[johnny52]

=INDEX(A:H,ROUNDUP(ROWS($1:1)/8,0),MOD(ROWS($1:1)+7,8)+1)

looked through some of my old posts not realizing I encountered this issue before, and it looks like this will work.

Thanks for the help