Sort Data from one column to Separate Columns

Thank xenixman

Unfortuantly my initial post doesn't really show the layout properly and after trying your formula I couldn't get it to work in this case.

The top 2/3 of the attachment is an example of the current layout information in seperate columns. It repeats the same format continuously down to about 800 (stupid and annoying).

The bottom 3 columns is how I would like it to look. Removing the first column all together (making it the column headings) and just having an easy to use table, that I can use as I wish with (vlookups, filters,pivot tables etc)

There is more information invloved but provided a formula to work in this case, should mean I can apply it to the full table. I am not a total novice like I implied, normally I can work these things out but this has me stumped. Everything I try returns jumbled columns, #ref or #value as results.

could a Macro be more effective in this instance?

Thanks