Splitting a single column

[andygas100]

Hi

I have a pharmacy products spreadsheet containing a large amount of data (27,000 entires) in a single column in the following format:


,TENS PADS (no form) 5cm x 5cm
4 Unit pack = #0.00
Total #0.00

-CEFALEXIN Tablets 125 mg
100 Tablet carton = #0.00
Total #0.00


-CLEARVIEW HCG PREGNANCY TESTING Kit (no strength)
20 Test pack = #0.00
Total #0.00

What I'm trying to do is split this column up so that the data is held in 3 columns that allows it to be filtered and sorted easily. So for example the following format displays product, unit and unit price:


Product-------------------------------------------Unit---------------------Price

TENS PADS (no form) 5cm x 5cm--------------4 unit pack------------#0.00
CEFALEXIN Tablets 125 mg---------------------100 Tablet carton----#0.00
CLEARVIEW HCG PREGNANCY TESTING Kit----20 Test pack---------#0.00

Can anyone help me with the types of functions I could use to achieve this?

Cheers!