当前位置：首页 → 问答吧 → 行合并的问题，打结了，还望各位帮帮忙。

行合并的问题，打结了，还望各位帮帮忙。

时间：2011-11-07

来源：互联网

HTML code


<table width="100%" border="0" cellpadding="3" cellspacing="1" align="center" valign="top" class="cmenutitle">
                <tr>
                    <td class="td_menu" rowspan="2"><div style="width:60px; text-align:center; font-weight:bold">客户</div></td>
                    
                    <td class="td_menu" colspan="4">2011-03</td>
                    
                    <td class="td_menu" colspan="4">2011-04</td>
                    
                    <td class="td_menu" colspan="4">2011-05</td>
                    
                    <td class="td_menu" colspan="4">2011-06</td>
                    
                    <td class="td_menu" colspan="4">2011-07</td>
                    
                </tr>
                <tr>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                </tr>
                
                <tr>
                    <td align="center">
                        LC
                    </td>
                    
                                <td>0</td>
                                <td>0</td>
                                <td>10000</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                </tr>
                
                <tr>
                    <td align="center">
                        LC
                    </td>
                    
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>63.49</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                </tr>
                
                <tr>
                    <td align="center">
                        LC
                    </td>
                    
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>10000</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                </tr>
                
            </table>

现在就是想让这三行信息合并到一行，类似于同列相加。但是又要根据时间来分开显示。结果期望如下（内容太长，见2楼回复）：

作者: kuzi1314 发布时间: 2011-11-07

HTML code


[code=HTML]<table width="100%" border="0" cellpadding="3" cellspacing="1" align="center" valign="top" class="cmenutitle">
                <tr>
                    <td class="td_menu" rowspan="2"><div style="width:60px; text-align:center; font-weight:bold">客户</div></td>
                    
                    <td class="td_menu" colspan="4">2011-03</td>
                    
                    <td class="td_menu" colspan="4">2011-04</td>
                    
                    <td class="td_menu" colspan="4">2011-05</td>
                    
                    <td class="td_menu" colspan="4">2011-06</td>
                    
                    <td class="td_menu" colspan="4">2011-07</td>
                    
                </tr>
                <tr>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额一(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额二(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额三(￥)</div></td>
                        <td><div style="width:50px; text-align:center; font-weight:bold">金额四(￥)</div></td>
                    
                </tr>
                
                <tr>
                    <td align="center">
                        LC
                    </td>
                    
                                <td>0</td>
                                <td>0</td>
                                <td>10000</td>
                                <td>0</td>
                                
                                <td>63.49</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                                <td>10000</td>
                                <td>0</td>
                                <td>0</td>
                                <td>0</td>
                                
                </tr>
                
            </table>

[/code]

作者: kuzi1314 发布时间: 2011-11-07

查询得到的数据如下：

HTML code


35    林场    LC    10000    63490    0    0    10000    0    0    0    63490    0    0.00    10000.00    2011-03
35    林场    LC    63.49    100    0    63.49    0    0    0    100    0    0    0.00    100.00    2011-04
35    林场    LC    10000    63490    0    10000    0    0    0    63490    0    0    0.00    10000.00    2011-07
36    林场2    LC2    10000    63490    0    10000    0    0    0    63490    0    0    0.00    10000.00    2011-07

现在就是将这个数据行变列，然后补齐3-7月间的数据，为空的记为0

作者: kuzi1314 发布时间: 2011-11-07