Excel 2000-2013 的表变形金刚将允许您快速轻松地转换当前表以构造透视表;将一个表分成几个表，或将两个表统一为一个表。 用于构建数据透视表的数据转换：Microsoft Excel 具有以数据透视表形式呈现数据的强大且方便的方法。但是，创建初始表通常需要进行其他转换。Excel 的表变形金刚将转换初始数据，并使其适合构建数据透视表。 表的划分：Excel 的表变形金刚会根据指定行数或指定列中单元格的唯一值将指定的表划分为多个表。若要根据指定的行数将当前表划分为多个表，必须指定新表开始的行数，并且表将立即划分。程序可以自动复制每个新表中的列名称，并在当前工作表或新工作表中放置新表。根据唯一值划分表的选项将允许您为单元格的每个唯一值创建单独的表。 将两个表合并为一个：Excel 的表变形金元将合并两个表，并分组此数据。例如，您有一个表，其中包含货物的名称及其数量，另一个表包含货物名称、交货日期、供应商和价格。使用此选项，您可以统一这两个表，根据货物名称进行分组。结果，您将得到一个包含 5 列的表：名称、交货日期、供应商和价格。此选项还允许您选择要包含在新表中的数据，以及选择新表的排列。所有数据保持不变。 产品主页： http://office-excel.com/excel-addins/tables-transformer.html
版本历史记录
- 版本 1.3.3 发布于 2013-03-07
已添加对 Microsoft Excel 2013 的支持。 - 版本 1.1.4 发布于 2007-10-17
已添加转换表时对单元格格式的考虑。
软件信息
- 软件分类： 业务 > 办公套房和工具
- 发布者： MAPILab Ltd.
- 许可： 免费试用
- 价格： $39.00
- 版本： 1.3.3
- 适用平台： windows
终端用户许可协议
License Agreement By installing and using the software product (hereinafter referred to as the SOFTWARE) you agree to all the terms of this License. If you do not agree to any of the terms of this License, then do not install and use the SOFTWARE. 1. All the rights for the SOFTWARE belong to MAPILab Ltd., and they are protected by the copyright laws of the United Kingdom of Great Britain and by international treaties. 2. The SOFTWARE is not free. The SOFTWARE is not sold, the SOFTWARE is licensed. By accepting this license agreement, you get the limited license for use of THE SOFTWARE within the trial period. Upon expiration of this license, you have to obtain the license for use of the SOFTWARE from MAPILab Ltd. or from its authorized representative. Otherwise you should stop using the SOFTWARE and remove its files from your machine. 3. This license agreement, as well as the SOFTWARE use license, gives you non-exclusive right to use the SOFTWARE with the limitations this agreement explicitly provides for. 4. You can distribute unmodified copies of the SOFTWARE without any limitations and without permission or license from the copyright owner. You can include the SOFTWARE into any software packages on floppy disks, CD-ROM or other medium, place it on an Internet site, or distribute it through other networks. 5. The license for use of the SOFTWARE gives you the non-exclusive right to install the SOFTWARE and use it on computers which number depends on the license type. If the SOFTWARE is installed in a local network for shared usage, the number of computers specified in the license should correspond to the number of the computers the SOFTWARE is launched on. License for use of the SOFTWARE doesn't impose any limitations on duration of the period of use (except for special limited trial use license); the license grants you a right to get updates of the SOFTWARE for free within one year and your right for technical support of the SOFTWARE within two years. The license for getting the SOFTWARE updates and technical support can be prolonged on advantageous terms. 6. The license for the SOFTWARE cannot be sold or transferred to third parties or leased without written permission of the copyright owner. 7. The license gives you no right for to modify, decompile, disassemble, and clone the SOFTWARE, except for the cases where such actions are explicitly permitted by the legislation of the United Kingdom of Great Britain and within the limits stated in such legislation. 8. MAPILab Ltd. gives no warranty that the SOFTWARE meets your requirements. The purpose of the limited trial license is to give you an opportunity to evaluate whether the SOFTWARE meets your requirements. After you obtain the license for use of the SOFTWARE, you can't claim any refund of its cost with the reasoning that the SOFTWARE doesn't meet your requirements or it used to meet them but doesn't any more. 9. MAPILab Ltd. is not liable for the loss of profit or any other damage occurred due to your use or improper use of the SOFTWARE. You use the SOFTWARE at your own risk. 10. MAPILab Ltd. reserves all the rights not explicitly stated in the license. 11. Failure comply with the provisions of this license agreement automatically results in termination of the SOFTWARE use license and may result in administrative and/or criminal prosecution. 12. By installing and using the SOFTWARE you accept the terms of the license agreement. If you disagree with any provisions of the license, remove the SOFTWARE files from your media and cease using it.