EXCEL - Re-organising data into another format

Hi,

I need to take the information from the spreadsheet called 'PPH - AC Pricelist' and organising into the format on 'PPH AC Pricelist template'.

I have already started to document the format required onto the template using the first chunk of data on the PPH - AC Pricelist, please follow this format for the rest of the information.

The product descriptions have product codes at the start of them, these product codes need to copied out and inputted into the product code column as already shown in the examples on the PPH - AC Pricelist document, prices need to be copied into the price column.

Any questions please ask.

Thank you!