Extracting Specific Data

Hi I need help with taking data from different rows and columns and putting them next to each other so is easy to capture. I have this mock-up example i got but it is what i need to do. I need to take the data colored in yellow and put it on a different row on a new sheet next to each other for e.g:

PIE45: Mutton Curry: R 9.90 R 2.58 R 8.68
Each one on a new column.

thats all i need to get from all the data there. but dunno the easiest way to retrieve it.

Any suggestions would be great.

Hello,
I am not sure if this will help u but try following steps

1. Put cursor in cell A6 (where PE45 :...... is entered)
2. Then select "Data" option -> "Text to Column" from Menu
3. Choose option "Fixed Wisth"
4. Click "Next" Then "click "Finish"


Bye

Thanx alot did help