Convert Excel table into input

[tmdspam]

I have searched the forum and can't find how to do what I need to do.

I have a sheet like the following

ID,Name1,Name2,Name3,Name4,Name5
1,aa,ab,ac,ad,ae
2,ba,bb,bc,bd,bd

I need to convert it to

ID,Name,value
1,Name1,aa
1,Name2,ab
1,Name3,ac
1,Name4,ad
1,Name5,ae
2,Name1,ba
2,Name2,bb
2,Name3,bc
2,Name4,bd
2,Name5,be

The original sheet will have a variable number of rows. I need to do this so the DBA can run a script off a csv file and stick the data in a database.

Can anyone help?

Me