Convert Excel cell data to a column header?

Hi! I have an Excel spreadsheet exported from an online e-commerce site I am working on. I get a column of cells that show something like this:

Product ID: 32
Product ID: 21
Product ID 72
And so on…

What I would like to do is to have Excel take “Product ID” and set it as the column header and delete it from the cells. Is there a way to do this? I have many similar cells (Product SKU: 1234, Product Quantity: 3, Produce Name:... and so on). I will be getting this report twice a month and I would hate to have to do all of this manually. I am an Excel newbie, so any help would be greatly appreciated! I have heard about Macros, but haven’t gone down that path yet. I am using Excel for Mac 2011 (no flames about Mac, please… this is what I was given).

Thanks!
-M