B1:

=TRIM(MID(SUBSTITUTE(TRIM($A1)," ",REPT(" ",100)),MAX((COLUMN(A1)-1)*100,1),100))

Copy over and down