Moving headers and cell information

I have an extensive Excel file that was converted from a PDF. That is my problem because it does not put the information on the sheet the way I need it to so I can upload it to a database. Right now I have to type in all the information which is taking forever. Here is what I need. You would be saving me tons of hours if this can be done.

The file is attached: It needs to look like this:

StudentID (Which in this example is 169058) needs to have it's own column
Name, (In this example is Doe, John) needs to have it's own column
DOB
Description, own column
Teachers, own column
H1, H2, H3, H4, Fin, Avg Fin, all have it's own column.

I don't need the rest. As you will see in the attachment the headers are on the top and the information is inside the cells. I have 2500 students like this. So hopefully it would look like this:

StuID, Name, DOB, Description, Teacher, H1, H2, H3, H4, Fin, Avg Fin.

Can this be done?

Hello taichi56,

The macro below has been added to the attached workbook. The reformatted results are appear on "Sheet2". There is button to run the macro in cell "B1".

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.

Man you guys are awesome. It is exactly what I need. I just need to add a column title Period and Avg Fin. I am working on it to see if I can get it, but probably not.

I figured it out. Thank you guys.