Cinstreshick
New Member
- Joined
- Apr 20, 2011
- Messages
- 1
I'm trying to do a simple collapse of days of the week and then a 2nd level collapse of the weeks into each month
My data is in columns and is very simple but I"m having trouble getting each week to collapse into it's own group.
<table width="960" border="0" cellpadding="0" cellspacing="0"><col width="64"><col width="64"><col width="64"><col width="64"><col width="64"><col width="64" span="4"><col width="64"><col width="64" span="5"><tr height="30"> <td class="xl65" style="height: 22.5pt; width: 48pt;" width="64" align="right" height="30">4/11</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/12</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/13</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/14</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/15</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/18</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/19</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/20</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/21</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/22</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/25</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/26</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/27</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/28</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/29</td> </tr></table>
I don't have any numerical detail under the columns so a pivot table doesn't make sense.
Help!!
My data is in columns and is very simple but I"m having trouble getting each week to collapse into it's own group.
<table width="960" border="0" cellpadding="0" cellspacing="0"><col width="64"><col width="64"><col width="64"><col width="64"><col width="64"><col width="64" span="4"><col width="64"><col width="64" span="5"><tr height="30"> <td class="xl65" style="height: 22.5pt; width: 48pt;" width="64" align="right" height="30">4/11</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/12</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/13</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/14</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/15</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64" align="right">4/18</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/19</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/20</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/21</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/22</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/25</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/26</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/27</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/28</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64" align="right">4/29</td> </tr></table>
I don't have any numerical detail under the columns so a pivot table doesn't make sense.
Help!!
