K
Kwasi
Here is some sample data:
22-Nov 36.5
23-Nov 28.2
24-Nov 29.2
25-Nov 34.3
26-Nov 31.9
27-Nov 36.4
28-Nov 41.8
29-Nov 34.5
30-Nov 31.0
1-Dec 30.3
2-Dec 37.0
3-Dec 39.8
4-Dec 36.9
5-Dec 32.8
6-Dec 35.7
I want to transform it into a table like this
Jan Feb .... Nov Dec
1 30.3
2 37.0
3 39.8
4 36.9
5 32.8
6 35.7
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 36.5
23 28.2
24 29.2
25 34.3
26 31.9
27 36.4
28 41.8
29 34.5
30 31.0
31
Could someone help me?
22-Nov 36.5
23-Nov 28.2
24-Nov 29.2
25-Nov 34.3
26-Nov 31.9
27-Nov 36.4
28-Nov 41.8
29-Nov 34.5
30-Nov 31.0
1-Dec 30.3
2-Dec 37.0
3-Dec 39.8
4-Dec 36.9
5-Dec 32.8
6-Dec 35.7
I want to transform it into a table like this
Jan Feb .... Nov Dec
1 30.3
2 37.0
3 39.8
4 36.9
5 32.8
6 35.7
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 36.5
23 28.2
24 29.2
25 34.3
26 31.9
27 36.4
28 41.8
29 34.5
30 31.0
31
Could someone help me?