Assuming you will copy the formulas past where the last data row would output results (in anticipation of future data perhaps)...
If you don't mind zeros at the bottom of your output for blank cells after the end of your data, then you can use this formula...
Formula:
=IFERROR(0+SUBSTITUTE(TRIM(MID(SUBSTITUTE(" "&INDEX(SUBSTITUTE($B:$B," ","",3),2*ROW()-1)," ",REPT(" ",999)),(2*COLUMNS($A:A)-1)*999,999)),",","."),0)
otherwise this formula will hide those zeros at the bottom of the output columns...
Formula:
=IF(ISNUMBER(SEARCH("x",INDEX($B:$B,2*ROW()-1))),IFERROR(0+SUBSTITUTE(TRIM(MID(SUBSTITUTE(" "&INDEX(SUBSTITUTE($B:$B," ","",3),2*ROW()-1)," ",REPT(" ",999)),(2*COLUMNS($A:A)-1)*999,999)),",","."),0),"")
Put which ever formula you chose in cell H2 and copy across to I2, then copy H2:I2 down as far as you think you will ever need.
Bookmarks