How to transpose rows for 3 different columns?

Hi, I'm new here so I apologize for my question's lack of clarity.
I want to:
1. Move my C columns to be a header column
2. Move the D column to be under the same C column
3. Remove any duplicate A and B column after moving column C and D
I think its better if I post a picture of what I'm trying to accomplish.
excelquestion.png

Link to same question from another forum: http://www.mrexcel.com/forum/excel-q...o-headers.html