Duplicating header data as row data

[taichi56]

Please Login or Register  to view this content.

I have an EXCEL spreadsheet that has 8,000 rows of this kind of information. It is downloaded from the database this way. I have to re-arrange it to fit our database. How can I put the StudentID (169058) and Name (Doe,John) beside each line that belongs to that student? I do not need the DOB, Cur Bldg: 2 Status: A or Gr: 11. Those fields are already populated and I do my import based on the studentID (169058), Thank you. ExcelForum_Mon Dec 3 2012.xlsx

[DobbsHead]

Your question is unclear. Could you format that example section how you'd like the final format to look?

[jaslake]

Hi taichi56

Try this

Please Login or Register  to view this content.

[taichi56]

Excellent, Thank you for your quick response and help.

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.