Spreadsheet: 215475d1361388658-fill-in-vertical-values-to-selected-area-with-horisontal-orientation-fill-in-selected-data
Sheet: Sheet2

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | Mean daily
 |  | S | 1 | Aug
 |  | M | 2 | Aug
 |  | T | 3 | Aug
 |  | W | 4 | Aug
 |  | T | 5 | Aug
 |  | F | 6 | Aug
 |  | S | 7 | Aug
 |  | S | 8 | Aug
 |  | M | 9 | Aug
 |  | T | 10 | Aug
 |  | W | 11 | Aug
 |  | T | 12 | Aug
 |  | F | 13 | Aug
 |  | S | 14 | Aug
 |  | S | 15 | Aug
 |  | M | 16 | Aug
 |  | T | 17 | Aug
 |  | W | 18 | Aug
 |  | T | 19 | Aug
 |  | F | 20 | Aug
 |  | S | 21 | Aug
 |  | S | 22 | Aug
 |  | M | 23 | Aug
 |  | T | 24 | Aug
 |  | W | 25 | Aug
 |  | T | 26 | Aug
 |  | F | 27 | Aug
 |  | S | 28 | Aug
 |  | S | 29 | Aug
 |  | M | 30 | Aug
 |  | T | 31 | Aug
 |  |  |  | Mean hourly
 |  | vertical values to fil in yellow space |  |  |  |  |  |  |  | I want to put the whole content of the vertical blue column in the yellow area above but with horisontal orientation startin from f4 to [NAME] and f5 to AC 5 and so on
 |  | 19.03 | ****
 |  | 25.04
 |  | 11.35
 |  | 17.02
 |  | 15.18
 |  | 12.98
 |  | 16.55
 |  | 20.12
 |  | 18.68
 |  | 14.91
 |  | 9.95
 |  | 21.62
 |  | 17.38
 |  | 18.62
 |  | 24.57
 |  | 15.14
 |  | 15.15
 |  | 24.71
 |  | 26.84
 |  | 24.04
 |  | 32.48
 |  | 30.48
 |  | 23.05
 |  | 26.64
 |  | 27.61
 |  | 22.96
 |  | 22.87
 |  | 23.76
 |  | 18.92
 |  | 17.49
 |  | 21.10
 |  | 32.94
 |  | 48.47
 |  | 78.70
 |  | 69.88
 |  | 77.70
 |  | 49.83
 |  | 25.09
 |  | 42.61
 |  | 36.21
 |  | 45.33
 |  | 65.01
 |  | 71.80
 |  | 65.56
 |  | 56.24
 |  | 66.28
 |  | 89.80
 |  | 111.90
 |  | 109.20
 |  | 90.10
 |  | 56.23
 |  | 48.32
 |  | 46.98
 |  | 41.45
 |  | 50.61
 |  | 61.86
 |  | 52.78
 |  | 77.80
 |  | 99.90
 |  | 64.71
 |  | 81.40
 |  | 105.20
 |  | 132.40
 |  | 137.90
 |  | 108.40
 |  | 128.70
 |  | 86.90
 |  | 80.70
 |  | 97.80
 |  | 97.80
 |  | 79.20
 |  | 98.60
 |  | 101.90
 |  | 80.30
 |  | 85.30
 |  | 82.00
 |  | 64.37
 |  | 56.66
 |  | 58.49
 |  | 69.95
 |  | 110.00
 |  | 162.10
 |  | 163.90
 |  | 104.40
 |  | 89.10
 |  | 110.60
 |  | 91.10
 |  | 91.60
 |  | 77.30
 |  | 68.66
 |  | 91.00
 |  | 83.40
 |  | 97.20
 |  | 111.10
 |  | 98.90
 |  | 103.10
 |  | 86.50
 |  | 75.50
 |  | 73.50
 |  | 49.93
 |  | 51.90
 |  | 58.79
 |  | 63.22
 |  | 104.70
 |  | 119.40
 |  | 121.60
 |  | 107.10
 |  | 110.50
 |  | 103.10
 |  | 113.80
 |  | 162.50
 |  | 125.70
 |  | 160.50
 |  | 160.20
 |  | 163.20
 |  | 115.20
 |  | 73.30
 |  | 93.50
 |  | 92.70
 |  | 103.10
 |  | 98.70
 |  | 93.80
 |  | 91.10
 |  | 99.10
 |  | 91.00
 |  | 59.57
 |  | 91.50
 |  | 103.60
 |  | 91.00
 |  | 83.50
 |  | 118.30
 |  | 109.80
 |  | 96.00
 |  | 72.10
 |  | 59.86
 |  | 81.50
 |  | 74.20
 |  | 72.40
 |  | 80.00
 |  | 101.80
 |  | 112.90
 |  | 102.70
 |  | 101.10
 |  | 108.60
 |  | 134.50
 |  | 93.50
 |  | 83.00
 |  | 83.10
 |  | 64.26
 |  | 58.98
 |  | 70.40
 |  | 77.20
 |  | 73.70
 |  | 75.40
 |  | 68.12
 |  | 63.47
 |  | 55.92
 |  | 56.77
 |  | 45.91
 |  | 42.05
 |  | 70.10
 |  | 73.80
 |  | 64.67
 |  | 62.41
 |  | 47.65
 |  | 53.01
 |  | 57.19
 |  | 50.01
 |  | 55.40
 |  | 55.74
 |  | 65.63
 |  | 63.10
 |  | 56.79
 |  | 51.17
 |  | 52.49
 |  | 56.66
 |  | 58.06
 |  | 68.12
 |  | 64.37
 |  | 55.14
 |  | 86.20
 |  | 81.30
 |  | 57.94
 |  | 34.05
 |  | 44.20
 |  | 63.24
 |  | 62.74
 |  | 43.38
 |  | 52.11
 |  | 75.60
 |  | 77.00
 |  | 63.61
 |  | 48.70
 |  | 63.70
 |  | 62.71
 |  | 46.76
 |  | 63.80
 |  | 46.81
 |  | 48.32
 |  | 58.34
 |  | 71.80
 |  | 138.40
 |  | 150.70
 |  | 71.30
 |  | 22.86
 |  | 3.16
 |  | 3.88
 |  | 15.87
 |  | 13.17
 |  | 35.15
 |  | 22.70
 |  | 50.97
 |  | 34.09
 |  | 19.26
 |  | 31.09
 |  | 39.08
 |  | 28.70
 |  | 33.74
 |  | 37.65
 |  | 27.64
 |  | 20.91
 |  | 28.81
 |  | 36.29
 |  | 39.24
 |  | 20.78
 |  | 23.57
 |  | 29.46
 |  | 16.78
 |  | 26.01
 |  | 37.91
 |  | 30.65
 |  | 35.28
 |  | 71.90
 |  | 30.73
 |  | 46.10
 |  | 74.60
 |  | 84.20
 |  | 80.00
 |  | 71.10
 |  | 73.20
 |  | 70.40
 |  | 47.32
 |  | 39.70
 |  | 31.53
 |  | 39.67
 |  | 51.98
 |  | 66.74
 |  | 150.90
 |  | 125.00
 |  | 99.10
 |  | 75.20
 |  | 87.40
 |  | 86.00
 |  | 61.88
 |  | 50.43
 |  | 44.41
 |  | 58.56
 |  | 91.70
 |  | 69.28
 |  | 62.06
 |  | 66.17
 |  | 73.50
 |  | 83.20
 |  | 73.50
 |  | 65.04
 |  | 57.99
 |  | 45.85
 |  | 49.02
 |  | 71.60
 |  | 87.00
 |  | 92.80
 |  | 110.30
 |  | 122.10
 |  | 121.70
 |  | 78.00
 |  | 72.90
 |  | 66.75
 |  | 46.76
 |  | 42.29
 |  | 44.72
 |  | 67.75
 |  | 79.90
 |  | 67.23
 |  | 96.90
 |  | 97.40
 |  | 81.90
 |  | 71.10
 |  | 87.10
 |  | 74.10
 |  | 77.30
 |  | 74.90
 |  | 74.20
 |  | 74.40
 |  | 77.60
 |  | 79.60
 |  | 81.10
 |  | 98.00
 |  | 136.90
 |  | 145.80
 |  | 128.60
 |  | 86.30
 |  | 56.11
 |  | 57.14
 |  | 35.30
 |  | 35.59
 |  | 20.97
 |  | 6.36
 |  | 14.67
 |  | 9.58
 |  | 8.54
 |  | 5.89
 |  | 5.66
 |  | 6.53
 |  | 7.15
 |  | 5.34
 |  | 4.61
 |  | 6.05
 |  | 8.35
 |  | 4.39
 |  | 2.43
 |  | 5.63
 |  | 6.15
 |  | 5.25
 |  | 6.54
 |  | 7.44
 |  | 6.89
 |  | 7.16
 |  | 14.02
 |  | 16.59
 |  | 19.38
 |  | 19.95
 |  | 24.84
 |  | 23.27
 |  | 16.47
 |  | 12.65
 |  | 12.74
 |  | 14.58
 |  | 12.17
 |  | 12.07
 |  | 12.92
 |  | 13.61
 |  | 16.85
 |  | 17.78
 |  | 25.70
 |  | 31.66
 |  | 32.64
 |  | 37.81
 |  | 49.71
 |  | 67.35
 |  | 47.90
 |  | 48.64
 |  | 57.05
 |  | 37.05
 |  | 49.92
 |  | 46.13
 |  | 30.11
 |  | 18.10
 |  | 25.58
 |  | 21.65
 |  | 18.47
 |  | 16.06
 |  | 13.85
 |  | 10.30
 |  | 15.88
 |  | 19.56
 |  | 42.52
 |  | 50.84
 |  | 50.32
 |  | 68.82
 |  | 42.49
 |  | 37.38
 |  | 35.41
 |  | 43.02
 |  | 44.54
 |  | 44.51
 |  | 43.13
 |  | 44.29
 |  | 44.81
 |  | 41.55
 |  | 46.51
 |  | 46.52
 |  | 32.20
 |  | 31.09
 |  | 23.28
 |  | 21.68
 |  | 16.73
 |  | 15.08
 |  | 18.78
 |  | 28.18
 |  | 26.42
 |  | 30.57
 |  | 62.59
 |  | 58.93
 |  | 46.80
 |  | 60.80
 |  | 43.15
 |  | 36.97
 |  | 34.93
 |  | 28.00
 |  | 27.50
 |  | 31.28
 |  | 21.97
 |  | 21.56
 |  | 22.03
 |  | 25.75
 |  | 24.22
 |  | 23.37
 |  | 24.61
 |  | 17.65
 |  | 25.31
 |  | 20.85
 |  | 21.98
 |  | 27.54
 |  | 36.81
 |  | 25.92
 |  | 42.81
 |  | 34.34
 |  | 23.02
 |  | 36.48
 |  | 40.82
 |  | 44.40
 |  | 46.39
 |  | 36.30
 |  | 38.77
 |  | 44.22
 |  | 39.24
 |  | 40.35
 |  | 38.66
 |  | 33.90
 |  | 28.42
 |  | 34.64
 |  | 28.38
 |  | 27.28
 |  | 37.26
 |  | 35.93
 |  | 32.45
 |  | 37.05
 |  | 40.17
 |  | 39.55
 |  | 54.43
 |  | 49.30
 |  | 49.16
 |  | 50.82
 |  | 34.08
 |  | 21.93
 |  | 37.91
 |  | 29.25
 |  | 36.34
 |  | 42.44
 |  | 45.35
 |  | 36.97
 |  | 30.76
 |  | 28.96
 |  | 24.65
 |  | 17.54
 |  | 17.05
 |  | 25.10
 |  | 21.59
 |  | 24.75
 |  | 18.96
 |  | 12.56
 |  | 20.83
 |  | 24.91
 |  | 32.06
 |  | 20.07
 |  | 25.85
 |  | 29.04
 |  | 29.42
 |  | 34.42
 |  | 34.52
 |  | 33.00
 |  | 28.80
 |  | 36.40
 |  | 32.04
 |  | 31.43
 |  | 38.34
 |  | 44.48
 |  | 38.61
 |  | 46.50
 |  | 40.82
 |  | 33.39
 |  | 35.39
 |  | 28.88
 |  | 28.05
 |  | 20.94
 |  | 21.89
 |  | 21.24
 |  | 27.22
 |  | 17.59
 |  | 26.42
 |  | 20.67
 |  | 31.03
 |  | 49.97
 |  | 78.30
 |  | 57.81
 |  | 57.30
 |  | 48.36
 |  | 41.37
 |  | 49.52
 |  | 59.45
 |  | 40.08
 |  | 42.69
 |  | 30.37
 |  | 31.42
 |  | 33.42
 |  | 31.43
 |  | 30.90
 |  | 31.81
 |  | 32.91
 |  | 39.25
 |  | 45.02
 |  | 54.42
 |  | 67.82
 |  | 61.24
 |  | 66.01
 |  | 62.43
 |  | 62.61
 |  | 56.27
 |  | 46.45
 |  | 38.93
 |  | 42.58
 |  | 52.59
 |  | 75.80
 |  | 58.08
 |  | 59.24
 |  | 52.90
 |  | 50.49
 |  | 58.44
 |  | 52.30
 |  | 55.09
 |  | 50.96
 |  | 65.41
 |  | 73.80
 |  | 85.60
 |  | 114.90
 |  | 121.90
 |  | 128.70
 |  | 95.20
 |  | 83.50
 |  | 40.61
 |  | 49.75
 |  | 54.72
 |  | 76.70
 |  | 83.60
 |  | 89.10
 |  | 92.40
 |  | 64.88
 |  | 88.60
 |  | 112.80
 |  | 105.00
 |  | 120.50
 |  | 101.40
 |  | 82.80
 |  | 68.26
 |  | 69.87
 |  | 51.75
 |  | 46.82
 |  | 68.44
 |  | 55.94
 |  | 54.27
 |  | 60.74
 |  | 54.56
 |  | 39.44
 |  | 51.90
 |  | 62.65
 |  | 52.02
 |  | 43.52
 |  | 60.76
 |  | 74.20
 |  | 76.70
 |  | 89.00
 |  | 93.50
 |  | 80.20
 |  | 60.26
 |  | 67.42
 |  | 67.25
 |  | 59.04
 |  | 63.04
 |  | 63.05
 |  | 57.16
 |  | 84.80
 |  | 82.30
 |  | 147.70
 |  | 149.40
 |  | 184.80
 |  | 113.10
 |  | 85.40
 |  | 56.67
 |  | 41.26
 |  | 66.36
 |  | 62.73
 |  | 56.47
 |  | 78.60
 |  | 112.60
 |  | 103.80
 |  | 122.90
 |  | 117.30
 |  | 86.10
 |  | 75.50
 |  | 62.57
 |  | 69.19
 |  | 59.76
 |  | 63.28
 |  | 40.06
 |  | 21.34
 |  | 26.62
 |  | 34.01
 |  | 31.94
 |  | 35.13
 |  | 32.26
 |  | 26.73
 |  | 23.03
 |  | 17.98
 |  | 24.33
 |  | 28.26
 |  | 47.59
 |  | 55.69
 |  | 47.88
 |  | 43.88
 |  | 59.41
 |  | 59.75
 |  | 25.81
 |  | 34.28
 |  | 51.73
 |  | 59.68
 |  | 60.26
 |  | 68.55
 |  | 62.14
 |  | 46.51
 |  | 62.48
 |  | 47.64
 |  | 52.23
 |  | 43.93
 |  | 33.66
 |  | 42.35
 |  | 35.52
 |  | 28.57
 |  | 25.98
 |  | 40.36
 |  | 39.54
 |  | 53.39
 |  | 31.45
 |  | 40.82