How to transpose rows for 3 different columns?

[stan255]

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

[AliGW]

Please provide the Excel workbook. You also need to provide a link to the cross-post that you have just made on another forum in order to fulfil this forum's rules.

Will there only ever be three types of degree at any school (1, 3, 5)?

[stan255]

Hey Ali,
Here's the link to the workbook as you requested.
https://www.dropbox.com/s/fmhie2u1zd...jor8.xlsx?dl=0
The main file is very huge with over 170,000 rows.

To answer your question:
There is 17 degree types. Not all schools have all 17 degree types. Some have 12. Some have 2. Some have 10, etc.

[stan255]

What should be the main title for this Excel request?

[jindon]

This will take time for about 5 min to finish.

Run it at your own risk.

Please Login or Register  to view this content.

[karedog]

As an alternative :

Please Login or Register  to view this content.

[stan255]

Hey jindon and karedog,
Both your VBAs work! Thank you so much!
I love you guys!
+ rep for both of you