Here!

Put in in Cell B1 and Drag Across -

=MID($A$1,(COLUMN(A1)*12)+1-12,6)

Assumed that you need Alex with 01 & Alex & Fred would appear alternately.

If not, then please specify further.

Deep