Results 1 to 4 of 4

Moving headers and cell information

Threaded View

taichi56 Moving headers and cell... 02-25-2011, 01:49 PM
Leith Ross Re: Moving headers and cell... 02-25-2011, 03:36 PM
mrice Re: Moving headers and cell... 02-25-2011, 04:10 PM
taichi56 Solved 02-25-2011, 05:38 PM
  1. #1
    Forum Contributor
    Join Date
    05-04-2008
    Posts
    103

    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?
    Attached Files Attached Files
    Last edited by taichi56; 02-25-2011 at 06:08 PM. Reason: SOLVED

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1