Excel Rookie - Duplicate Columns and rows with headings

Hi All,

I have a rather simple task i'm trying to complete, however i am a total rookie when it comes to excel, that or this task is not possible with excel.

I have attached two files:

One file called "original file"

This file has many "Custom ID"'s in one column relating to one food type, one of the rows in the sheet called "Description" has a number or descriptions i would like to use as headings.

In the file called finished work i have manually set it out how i would like it with the Custom ID shown only once and the descriptions shown as the heading now.

i have about 3000 lines to fix so i assume there would be a script i could run, can anyone let me know if its possible to complete this using excel?

thanks for helping in advanced.

Regards.

Hi Crooza,

Thanks for your prompt reply! i will look into Pivot tables asap!

I did just make up data for the demo i was wondering if people would notice

Thanks for your time.