{"id":21425,"date":"2024-05-31T10:43:48","date_gmt":"2024-05-31T09:43:48","guid":{"rendered":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/"},"modified":"2025-03-27T11:41:13","modified_gmt":"2025-03-27T11:41:13","slug":"tables-transformer-for-excel","status":"publish","type":"product","link":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/","title":{"rendered":"Tables Transformer for Excel"},"content":{"rendered":"<p>Fast and easy transformations of Excel tables. Prepare tabular data for the construction of pivot tables. Divide one table into several. Unite two tables in one.<\/p>\n<p>Tables Transformer for Excel will allow you to fast and easy perform the following transformations of Microsoft Excel tables:<\/p>\n<ul>\n<li>To prepare tabular data for the construction of pivot tables.<\/li>\n<li>To divide one table into several ones.<\/li>\n<li>To unite two tables in one.<\/li>\n<\/ul>\n<h2>Key Features:<\/h2>\n<ul>\n<li><strong>Data Transformation for the Contruction of Pivot Tables: <\/strong>Microsoft Excel has a powerful and convenient means of data presentation in the form of pivot tables. However, additional transformations of initial tables are often necessary for their creation. Tables Transformer for Excel will transform initial data and will make it suitable for the construction of the pivot table.<\/li>\n<li><strong>Division of Tables:<\/strong> Tables Transformer for Excel will divide the specified table into several ones on the basis of:\n<ul>\n<li>The specified number of rows: To divide the current table into several ones on the basis of the specified number of rows, you have to specify the number of the row from which a new table starts \u2013 and the table will be immediately divided. The program can automatically copy names of columns in each new table and place new tables in the current or new worksheet. For example, you have a monthly sales report per one year and you need to get four quarterly reports. Specify an interval of division &#8211; 3 rows and get four separate tables containing sales information per a quarter.<\/li>\n<li>Unique values of cells in the specified columns: The option of dividing the table according to unique values will allow you to create separate tables for each unique value of a cell. For example, you have a table which consists of three columns: type of a product, manufacturer and price. Using this option, you can get separate tables on each manufacturer.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Merging Two Tables in One: <\/strong>Tables Transformer for Excel will unite two tables in one with grouping of this data. For example, you have a table with names of the goods and their quantity and the other one containing the name of the goods, delivery date, supplier and price. Using this option, you can unite these 2 tables grouped according to the names of the goods. In the result, you will get a table containing 5 columns: name, delivery date, supplier and price. This option also allows you to choose the data to be included into a new table as well as to choose an arrangement of the new table. All the data remains unchanged.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Tables Transformer for Excel &#8211; Features<\/h2>\n<p><a name=\"4\"><\/a> <\/p>\n<div id=\"tocmenu\"> <A href=\"#features\">Features<\/A> <A href=\"#new\">New Features Version 1.1.4<\/A> <\/div>\n<p>Tables Transformer for Excel will allow you to fast and easy perform the following transformations of Microsoft Excel tables:   <\/p>\n<ul>\n<li>To prepare tabular data for the construction of pivot tables.\n<li>To divide one table into several ones.\n<li>To unite two tables in one.  <\/li>\n<\/ul>\n<p><h2><A name=\"features\"><\/A>Features<\/h2>\n<p><h4>Data transformations for the construction of pivot tables <\/h4>\n<p> Microsoft Excel has a powerful and convenient means of data presentation in the form of pivot tables. However, additional transformations of initial tables are often necessary for their creation. Tables Transformer for Excel will transform initial data and will make it suitable for the construction of the pivot table.   <\/p>\n<p><h4>Division of tables <\/h4>\n<p> Tables Transformer for Excel will divide the specified table into several ones on the basis of:  <\/p>\n<ul>\n<li>The specified number of rows;\n<li>Unique values of cells in the specified columns.  <\/li>\n<\/ul>\n<p>To divide the current table into several ones on the basis of the specified number of rows, you have to specify the number of the row from which a new table starts and the table will be immediately divided. The program can automatically copy names of columns in each new table and place new tables in the current or new worksheet. For example, you have a monthly sales report per one year and you need to get four quarterly reports. Specify an interval of division &#8211; 3 rows and get four separate tables containing sales information per a quarter.   <\/p>\n<p><h4>Merging two tables in one <\/h4>\n<p> Tables Transformer for Excel will unite two tables in one with grouping of this data. For example, you have a table with names of the goods and their quantity and the other one containing the name of the goods, delivery date, supplier and price. Using this option, you can unite these 2 tables grouped according to the names of the goods. In the result, you will get a table containing 5 columns: name, delivery date, supplier and price. This option also allows you to choose the data to be included into a new table as well as to choose an arrangement of the new table. All the data remains unchanged.  <\/p>\n<p><h2><A name=\"new\"><\/A>New Features Version 1.1.4<\/h2>\n<ul>\n<li>Algorithm of .NET Framework downloading was changed in the installation wizard.  <\/li>\n<\/ul>\n<p><A href=\"#4\" class=\"ilink\">Back to top<\/A><\/p>\n<h2>Tables Transformer for Excel &#8211; System Requirements<\/h2>\n<h4>System Requirements<\/h4>\n<p><strong>Operating system requirements:<\/strong> <\/p>\n<ul>\n<li>Microsoft Windows 98\n<li>Microsoft Windows 2000\n<li>Microsoft Windows 2003\n<li>Microsoft Windows XP\n<li>Microsoft Windows Vista  <\/li>\n<\/ul>\n<p><strong>Software requirements:<\/strong> <\/p>\n<ul>\n<li>Microsoft .NET Framework version 2.0\n<li>Microsoft Excel 2000\n<li>Microsoft Excel 2002 (XP)\n<li>Microsoft Excel 2003\n<li>Microsoft Excel 2007  <\/li>\n<\/ul>\n<p>Administrator privileges for the installation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fast and easy transformations of Excel tables. Prepare tabular data for the construction of pivot tables. Divide one table into several. Unite two tables in one. Tables Transformer for Excel will allow you to fast and easy perform the following transformations of Microsoft Excel tables: To prepare tabular data for the construction of pivot tables. [&hellip;]<\/p>\n","protected":false},"featured_media":78880,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false},"product_brand":[7423],"product_cat":[2021,2016],"product_tag":[],"class_list":{"0":"post-21425","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_brand-mapilab","7":"product_cat-desktop-applications","8":"product_cat-digital-workplace","10":"first","11":"outofstock","12":"shipping-taxable","13":"product-type-simple"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tables Transformer for Excel - QBS Software - French<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tables Transformer for Excel\" \/>\n<meta property=\"og:description\" content=\"Fast and easy transformations of Excel tables. Prepare tabular data for the construction of pivot tables. Divide one table into several. Unite two tables in one. Tables Transformer for Excel will allow you to fast and easy perform the following transformations of Microsoft Excel tables: To prepare tabular data for the construction of pivot tables. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"QBS Software - French\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-27T11:41:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/07\/tablestran-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1\" \/>\n\t<meta property=\"og:image:height\" content=\"1\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@qbssoftware\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/\",\"url\":\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/\",\"name\":\"Tables Transformer for Excel - QBS Software - French\",\"isPartOf\":{\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/tablestran-3.png\",\"datePublished\":\"2024-05-31T09:43:48+00:00\",\"dateModified\":\"2025-03-27T11:41:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#primaryimage\",\"url\":\"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/tablestran-3.png\",\"contentUrl\":\"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/tablestran-3.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.qbssoftware.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vendors\",\"item\":\"https:\/\/www.qbssoftware.com\/fr\/vendors\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Tables Transformer for Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/#website\",\"url\":\"https:\/\/www.qbssoftware.com\/fr\/\",\"name\":\"QBS Software\",\"description\":\"Software delivery platform\",\"publisher\":{\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.qbssoftware.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/#organization\",\"name\":\"QBS Software\",\"url\":\"https:\/\/www.qbssoftware.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/06\/qbs-logo-d-i.png\",\"contentUrl\":\"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/06\/qbs-logo-d-i.png\",\"width\":800,\"height\":800,\"caption\":\"QBS Software\"},\"image\":{\"@id\":\"https:\/\/www.qbssoftware.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/qbssoftware\",\"https:\/\/www.linkedin.com\/company\/qbs-software\/\",\"https:\/\/www.youtube.com\/user\/QBSSoftwareLtd\"],\"email\":\"info@qbssoftware.com\",\"telephone\":\"+44 (0) 20 8733 7100\",\"publishingPrinciples\":\"https:\/\/www.qbssoftware.com\/fr\/privacy-policy\/\",\"ethicsPolicy\":\"https:\/\/www.qbssoftware.com\/fr\/corporate-responsibility-charter\/\",\"diversityPolicy\":\"https:\/\/www.qbssoftware.com\/fr\/corporate-responsibility-charter\/\",\"diversityStaffingReport\":\"https:\/\/www.qbssoftware.com\/fr\/corporate-responsibility-charter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tables Transformer for Excel - QBS Software - French","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/","og_locale":"en_US","og_type":"article","og_title":"Tables Transformer for Excel","og_description":"Fast and easy transformations of Excel tables. Prepare tabular data for the construction of pivot tables. Divide one table into several. Unite two tables in one. Tables Transformer for Excel will allow you to fast and easy perform the following transformations of Microsoft Excel tables: To prepare tabular data for the construction of pivot tables. [&hellip;]","og_url":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/","og_site_name":"QBS Software - French","article_modified_time":"2025-03-27T11:41:13+00:00","og_image":[{"url":"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/07\/tablestran-2.png","width":1,"height":1,"type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@qbssoftware","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/","url":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/","name":"Tables Transformer for Excel - QBS Software - French","isPartOf":{"@id":"https:\/\/www.qbssoftware.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/tablestran-3.png","datePublished":"2024-05-31T09:43:48+00:00","dateModified":"2025-03-27T11:41:13+00:00","breadcrumb":{"@id":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#primaryimage","url":"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/tablestran-3.png","contentUrl":"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/tablestran-3.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.qbssoftware.com\/fr\/product\/tables-transformer-for-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.qbssoftware.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Vendors","item":"https:\/\/www.qbssoftware.com\/fr\/vendors\/"},{"@type":"ListItem","position":3,"name":"Tables Transformer for Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.qbssoftware.com\/fr\/#website","url":"https:\/\/www.qbssoftware.com\/fr\/","name":"QBS Software","description":"Software delivery platform","publisher":{"@id":"https:\/\/www.qbssoftware.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.qbssoftware.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.qbssoftware.com\/fr\/#organization","name":"QBS Software","url":"https:\/\/www.qbssoftware.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.qbssoftware.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/06\/qbs-logo-d-i.png","contentUrl":"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/06\/qbs-logo-d-i.png","width":800,"height":800,"caption":"QBS Software"},"image":{"@id":"https:\/\/www.qbssoftware.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/qbssoftware","https:\/\/www.linkedin.com\/company\/qbs-software\/","https:\/\/www.youtube.com\/user\/QBSSoftwareLtd"],"email":"info@qbssoftware.com","telephone":"+44 (0) 20 8733 7100","publishingPrinciples":"https:\/\/www.qbssoftware.com\/fr\/privacy-policy\/","ethicsPolicy":"https:\/\/www.qbssoftware.com\/fr\/corporate-responsibility-charter\/","diversityPolicy":"https:\/\/www.qbssoftware.com\/fr\/corporate-responsibility-charter\/","diversityStaffingReport":"https:\/\/www.qbssoftware.com\/fr\/corporate-responsibility-charter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product\/21425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/comments?post=21425"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/media\/78880"}],"wp:attachment":[{"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/media?parent=21425"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product_brand?post=21425"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product_cat?post=21425"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product_tag?post=21425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}