I have data that looks like this:
Top % Top % Top %
99.2 99.0 81.4 66.0 77.9 33.0
90.1 98.0 81.4 65.0 77.7 32.0
89.4 97.0 81.2 64.0 77.6 31.0
88.4 96.0 81.1 63.0 77.4 30.0
87.9 95.0 81.0 62.0 77.3 29.0
87.3 94.0 80.9 61.0 77.2 28.0
86.9 93.0 80.7 60.0 77.0 27.0
86.4 92.0 80.6 59.0 76.9 26.0
86.1 91.0 80.5 58.0 76.7 25.0
85.6 90.0 80.4 57.0 76.4 24.0
85.2 89.0 80.3 56.0 76.3 23.0
84.9 88.0 80.2 55.0 76.2 22.0
84.8 87.0 80.1 54.0 76.1 21.0
84.5 86.0 80.0 53.0 75.7 20.0
84.3 85.0 79.9 52.0 75.5 19.0
84.1 84.0 79.8 51.0 75.2 18.0
83.9 83.0 79.7 50.0 75.0 17.0
83.7 82.0 79.6 49.0 74.8 16.0
83.4 81.0 79.5 48.0 74.5 15.0
83.4 80.0 79.4 47.0 74.1 14.0
83.2 79.0 79.3 46.0 73.8 13.0
83.0 78.0 79.2 45.0 73.6 12.0
82.9 77.0 79.1 44.0 73.4 11.0
82.7 76.0 79.0 43.0 72.9 10.0
82.5 75.0 78.9 42.0 72.6 9.0
82.4 74.0 78.8 41.0 72.1 8.0
82.2 73.0 78.6 40.0 71.3 7.0
82.1 72.0 78.5 39.0 70.7 6.0
82.0 71.0 78.4 38.0 70.2 5.0
81.9 70.0 78.3 37.0 69.6 4.0
81.7 69.0 78.2 36.0 68.6 3.0
81.6 68.0 78.1 35.0 65.7 2.0
81.5 67.0 78.0 34.0 0.0 1.0
The columns are split like this for viewability from the generated report, but is there a quick way to "merge" these 6 columns into 2 columns? There are about 50 blocks of data like this so I really don't want to just manually copy and paste.
I can fumble my way through VBA well enough if there is an efficient VBA solution instead of a formulaic one.
Aucun commentaire:
Enregistrer un commentaire