Excel 2000-2013 的表變形金剛將允許您快速輕鬆地轉換當前表以構造透視表;將一個表分成幾個表，或將兩個表統一為一個表。 用於建譯資料透視表的資料轉換：Microsoft Excel 具有以資料透視表形式呈現資料的強大且方便的方法。但是，創建初始表通常需要進行其他轉換。Excel 的表變形金剛將轉換初始數據，並使其適合建構資料透視表。 表的劃分：Excel 的表變形金剛會根據指定行數或指定列中單元格的唯一值將指定的表劃分為多個表。若要根據指定的行數將當前表劃分為多個表，必須指定新表開始的行數，並且表將立即劃分。程式可以自動複製每個新表中的列名稱，並在當前工作表或新工作表中放置新表。根據唯一值劃分表的選項將允許您為儲存格的每個唯一值創建單獨的表。 將兩個表合併為一個：Excel 的表變形金元將合併兩個表，並分組此數據。例如，您有一個表，其中包含貨物的名稱及其數量，另一個表包含貨物名稱、交貨日期、供應商和價格。使用此選項，您可以統一這兩個表，根據貨物名稱進行分組。結果，您將得到一個包含 5 列的表：名稱、交貨日期、供應商和價格。這個選項還允許您選擇要包含在新表中的數據，以及選擇新表的排列。所有數據保持不變。
版本歷史記錄
- 版本 1.3.3 發佈於 2013-03-07
已添加轉換表時對儲存格格式的考慮。 - 版本 1 發佈於 2009-02-15
軟體細節
- 軟體分類： 業務 > 辦公套房和工具
- 發佈者： Office Assistance LLC
- 軟體性質： 免費試用
- 價格： $39.00
- 版本： 1.3.3
- 作業系統： windows
終端使用者許可協定
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. All the rights for the SOFTWARE belong to Office Assitance. 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 30-day trial period. Upon expiration of this license, you have to obtain the license for use of the SOFTWARE from Office Assitance or from its authorized representative. Otherwise you should stop using the SOFTWARE and remove its files from your machine. 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. 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. 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 and your right for technical support of the SOFTWARE for free within one year. The license for getting the SOFTWARE updates and technical support can be prolonged on advantageous terms. The license for the SOFTWARE cannot be sold or transferred to third parties or leased without written permission of the copyright owner. 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. Office Assitance 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 claim a 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 during 30-days only. Office Assitance 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. Office Assitance reserves all the rights not explicitly stated in the license. 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. 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.