Need Expert Excel Help

[Genius Gone Insane]

What's a fast way to reverse-transpose this:

Name Monday Tuesday Wednesday
Bob 3 6 9
Sam 4 7 10



into this:

Name Date Value
Bob Monday 3
Bob Tuesday 6
Bob Wednesday 9
Sam Monday 4
Sam Tuesday 7
Sam Wednesday 10



Obviously this is a small scale example of a much larger data set

 

[Genius Gone Insane]

meh nevermind, i got it using a pivot table and an if statement