Sql server DB has a table like
Input data:
Indicator name Jan-17 Feb-17 Mar-17
A 5 2 9
B 0 5 3
C 9 6 3
D 9 1 8
I want to see the output as follows, how do I do that in sql server?
Indicator Name Date Value
A Jan-17 5
A Feb-17 2
A Mar-17 9
B Jan-17 0
B Feb-17 5
B Mar-17 3
C Jan-17 9
C Feb-17 6
C Mar-17 3
D Jan-17 9
D Feb-17 1
D Mar-17 8