Copy and Pasting Days into different columns

segran · May 9, 2011

Hi,

I have 2 columns - one with day of the week and the other with data. Each day of the week has 24 data points associated with it.

<html><head><title>Excel Jeanie HTML</title></head><body>



<b>Hourly Data</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:99px;" /><col style="width:76px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >*</td><td >J</td><td >K</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#c0c0c0; font-weight:bold; ">Day</td><td style="background-color:#c0c0c0; font-weight:bold; ">Eritrea</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#c0c0c0; "> Saturday</td><td style="background-color:#c0c0c0; text-align:right; ">15.6</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">15</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">16.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">20</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">25.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">28</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29.6</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">31.88</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">32.95</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">32.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">26.95</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.01</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">30.2</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">36.94</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">38.72</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">36.762</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">33.336</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">24.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">21.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td style="background-color:#c0c0c0; "> Tuesday</td><td style="background-color:#c0c0c0; text-align:right; ">15.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.9</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >28</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >30</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">15.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >31</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">20.6</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >32</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >33</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >34</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">31.2</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >35</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">33.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >36</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">36.65</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >37</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">36.57</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >38</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">33.11</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >39</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29.9</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >40</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29.04</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >41</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">30.19</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >42</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">30.9</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >43</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">34.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >44</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">41.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >45</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">42.722</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >46</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">41.347</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >47</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">37.84</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >48</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">33.125</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >49</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">23.1</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >50</td><td style="background-color:#c0c0c0; ">Sunday</td><td style="background-color:#c0c0c0; text-align:right; ">17.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >51</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">16.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >52</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">16.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >53</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">17.6</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >54</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">17</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >55</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">15.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >56</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">23.695</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >57</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">23.378</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >58</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">26.52</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >59</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.349</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >60</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29.213</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >61</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">28.916</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >62</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.999</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >63</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">24.396</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >64</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.233</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >65</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">23.284</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >66</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">22.832</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >67</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">22.507</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >68</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">34.2</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >69</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">34.2</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >70</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">35.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >71</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >72</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">22.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >73</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">17.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >74</td><td style="background-color:#c0c0c0; ">Wednesday</td><td style="background-color:#c0c0c0; text-align:right; ">17.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >75</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">15.1</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >76</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >77</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >78</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">15.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >79</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">15.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >80</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >81</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">28.1</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >82</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">31.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >83</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">32.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >84</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">33.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >85</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">33.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >86</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >87</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">25.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >88</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">26</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >89</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">26.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >90</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">32.6</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >91</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">36.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >92</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">40.306</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >93</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">39.808</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >94</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">31.2</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >95</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">24.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >96</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">21.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >97</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">21.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >98</td><td style="background-color:#c0c0c0; ">Friday</td><td style="background-color:#c0c0c0; text-align:right; ">15.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >99</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >100</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >101</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">14.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >102</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">16.6</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >103</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">18.6</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >104</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">27.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >105</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">28.6</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >106</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">31.9</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >107</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">32.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >108</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">33.2</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >109</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">33.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >110</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29.2</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >111</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29.4</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >112</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">26.8</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >113</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">28.7</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >114</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">30.5</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >115</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">29.1</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >116</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">35.3</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >117</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">39.632</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >118</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">36.836</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >119</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">35.725</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >120</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">25.2</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >121</td><td style="background-color:#c0c0c0; ">*</td><td style="background-color:#c0c0c0; text-align:right; ">20.5

hiker95 · May 9, 2011

segran,

Sample data before the macro:

Excel Workbook

J

K

1

Day

Eritrea

2

Saturday

15.6

3

15

4

14.4

5

14.7

6

16.8

7

20

8

25.7

9

28

10

29.6

11

31.88

12

32.95

13

32.5

14

29

15

26.95

16

27.01

17

27.3

18

27.4

19

30.2

20

36.94

21

38.72

22

36.762

23

33.336

24

24.5

25

21.5

26

Tuesday

15.8

27

14.9

28

14.5

29

14.7

30

15.8

31

20.6

32

27.4

33

29.4

34

31.2

35

33.3

36

36.65

37

36.57

38

33.11

39

29.9

40

29.04

41

30.19

42

30.9

43

34.5

44

41.7

45

42.722

46

41.347

47

37.84

48

33.125

49

23.1

50

Sunday

17.5

51

16.8

52

16.3

53

17.6

54

17

55

15.7

56

23.695

57

23.378

58

26.52

59

27.349

60

29.213

61

28.916

62

27.999

63

24.396

64

27.233

65

23.284

66

22.832

67

22.507

68

34.2

69

34.2

70

35.4

71

29

72

22.3

73

17.8

74

Wednesday

17.8

75

15.1

76

14.3

77

14.8

78

15.3

79

15.8

80

27.5

81

28.1

82

31.7

83

32.8

84

33.5

85

33.3

86

29

87

25.5

88

26

89

26.4

90

32.6

91

36.4

92

40.306

93

39.808

94

31.2

95

24.4

96

21.7

97

21.7

98

Friday

15.4

99

14.7

100

14.5

101

14.5

102

16.6

103

18.6

104

27.5

105

28.6

106

31.9

107

32.8

108

33.2

109

33.3

110

29.2

111

29.4

112

26.8

113

28.7

114

30.5

115

29.1

116

35.3

117

39.632

118

36.836

119

35.725

120

25.2

121

20.5

122

Hourly Data

After the macro:

Excel Workbook

J

K

L

M

N

O

P

Q

R

S

T

U

V

1

Day

Eritrea

Saturday

15.6

Tuesday

15.8

Sunday

17.5

Wednesday

17.8

Friday

15.4

2

Saturday

15.6

15

14.9

16.8

15.1

14.7

3

15

14.4

14.5

16.3

14.3

14.5

4

14.4

14.7

17.6

14.8

14.5

5

14.7

16.8

15.8

17

15.3

16.6

6

16.8

20

20.6

15.7

15.8

18.6

7

20

25.7

27.4

23.695

27.5

8

25.7

28

29.4

23.378

28.1

28.6

9

28

29.6

31.2

26.52

31.7

31.9

10

29.6

31.88

33.3

27.349

32.8

11

31.88

32.95

36.65

29.213

33.5

33.2

12

32.95

32.5

36.57

28.916

33.3

13

32.5

29

33.11

27.999

29

29.2

14

29

26.95

29.9

24.396

25.5

29.4

15

26.95

27.01

29.04

27.233

26

26.8

16

27.01

27.3

30.19

23.284

26.4

28.7

17

27.3

27.4

30.9

22.832

32.6

30.5

18

27.4

30.2

34.5

22.507

36.4

29.1

19

30.2

36.94

41.7

34.2

40.306

35.3

20

36.94

38.72

42.722

34.2

39.808

39.632

21

38.72

36.762

41.347

35.4

31.2

36.836

22

36.762

33.336

37.84

29

24.4

35.725

23

33.336

24.5

33.125

22.3

21.7

25.2

24

24.5

21.5

23.1

17.8

21.7

20.5

25

21.5

26

Tuesday

15.8

Hourly Data

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Code:

Option Explicit
Sub ReorgData()
' hiker95, 05/09/2011
' http://www.mrexcel.com/forum/showthread.php?t=548702
Dim LR As Long, a As Long, NC As Long
Application.ScreenUpdating = True
LR = Cells(Rows.Count, "K").End(xlUp).Row
NC = 11
For a = 2 To LR Step 24
  NC = NC + 2
  Cells(1, NC).Resize(24, 2).Value = Range("J" & a).Resize(24, 2).Value
Next a
Range(Cells(2, 13), Cells(LR, NC + 1)).Columns.AutoFit
Application.ScreenUpdating = True
End Sub

Then run the ReorgData macro.

segran · May 9, 2011

Thank YoU

Copy and Pasting Days into different columns

segran

Active Member

Excel Facts

hiker95

Well-known Member

segran

Active Member

Similar threads

Forum statistics

Share this page

Copy and Pasting Days into different columns

segran

Active Member

Excel Facts

hiker95

Well-known Member

segran

Active Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock