Transpose Fields

[vardhancse]

Hi,

Have a requirement is that, have one table

Date	Canada	USA	UK	FRANCE
1/01/2015	10	20	30	40
2/01/2015	20	30	40	50
3/01/2015	30	40	50	60
4/01/2015	40	50	60	70
5/01/2015	50	60	70	80
6/01/2015	60	70	80	90
7/01/2015	70	80	90	100
8/01/2015	80	90	100	110
9/01/2015	90	100	110	120

After transposing the result is some thing like:

Date	Country	Value
1/01/2015	Canada	10
1/01/2015	USA	20
1/01/2015	UK	30
1/01/2015	FRANCE	40
2/01/2015	Canada	20
2/01/2015	USA	30
2/01/2015	UK	40
2/01/2015	FRANCE	50

Can please help me out to get the same.

[vardhancse]

Hi,

Is there any condition there should not be any fields after the country names.