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
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