splitting row into multiple columns

Originally Posted by azumi

Maybe something like this? Pls see the file attach


best regards

Hey Azumi,

The formula you gave me require some modification.

Here you are

Formula:

=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