How to rearrange a single row into multiple columns in Excel

Question

I have one array of zeros and ones in one row like this:

But I want to rearrange them to look like this, every 5 bits in one row:

Answer 1

with Office 365:

=INDEX($1:$1,SEQUENCE(INT(COUNT($1:$1)/5),5))

The result will spill.

with older versions use:

=INDEX($1:$1,((ROW($ZZ1)-1)*5)+COLUMN(A$1))

Copy over five columns and down till you get all 0