Text to column formula

[samvince]

Hi all,

So I've got a spreadsheet where all the data is like this

Box Charge FBA15G9R2TFN 20.0% S 4 2.50 10.00
UK Prep Fee FBA15G9R2TFN 20.0% S 66 0.50 33.00
UK Bundle Prep FBA15G9R2TFN 20.0% S 18 0.70 12.60
BUNDLE 4+ FBA15G9R2TFN 20.0% S 20 0.80 16.00

But I need the data to split like this.




Box Charge # FBA15G9R2TFN # 20.0% S # 4 # 2.5 # 10
UK Prep Fee # FBA15G9R2TFN # 20.0% S # 66 # 0.5 # 33
UK Bundle Prep # FBA15G9R2TFN # 20.0% S # 18 # 0.7 # 12.6
BUNDLE 4+ # FBA15G9R2TFN # 20.0% S # 20 # 0.8 # 16

The Hashtags are supposed to represent column lines.

Hope this makes sense.