Need Help to Restructure the table

[jeremiah_j2k]

Hello Guys,

I would like to ask your advise on how can we restructure the table from the attached spreadsheet. Can this be done using v/hlookup command or a macro? Below is the format that i need for me to be able to create a line graph for reporting purposes. Thanks in advanced for your help.


WeekNum Date Name SL SL2 VL VL2
1 1-Jan-15
1 2-Jan-15
1 3-Jan-15 John Doe 9 1
1 3-Jan-15 John Doe 12 1
1 3-Jan-15 John Doe 15 1
2 4-Jan-15
2 5-Jan-15 John Doe 2 1
2 6-Jan-15 John Doe 2 1
2 7-Jan-15 John Doe 2 1
2 8-Jan-15 John Doe 6 1
2 8-Jan-15 John Doe 13 1


Capture.PNG

- jeremiah_j2k