splitting row into multiple columns

[kisanvikas2015]

Hi all,

From a data like 1,2,3 till 20 in range A1:T1

Can I split the rows like following:

1 6 11 16
2 7 12 17
3 8 13 18
4 9 14 19
5 10 15 20

Regards,
Kisan Vikas

[Glenn Kennedy]

Maybe like this. Drag across and down to give the desired size.

=INDEX($A$1:$T$1,ROWS($D$4:$D4)+(COLUMNS($D$4:D$4)-1)*5)

[azumi]

Maybe something like this? Pls see the file attach


best regards

[kisanvikas2015]

Maybe something like this? Pls see the file attach


best regards

Hey Azumi,

The formula you gave me require some modification.

Here you are

=IFERROR(IF(ROWS(A1:$A$1)<=5,INDEX($A$1:$T$1,ROWS($A$1:A1)+(COLUMNS($A$1:A1)-1)*5),""),"")

Regards,
Kisan Vikas

[kisanvikas2015]

Thanks Glenn, Azumi & Siva

Your formulas are working perfectly fine.

Regards,
Kisan Vikas

[azumi]

Thanks for the feedback...........

[Glenn Kennedy]

Azumi - better than my effort, but the 4's need to be 5's, as in:

IFERROR(IF(ROWS($A$1:A1)<=5,INDEX($A$1:$T$1,ROWS($A$1:A1)+(COLUMNS($A$1:A1)-1)*5),""),"")

[samba_ravi]

=if(row(a1)>5,"",iferror(index($a$1:$t$1,row(a1)+column(a1)*5-5),""))
try this

[Glenn Kennedy]

Thanks for the feedback, but Azumi's and nflsales' are better!!