{"id":278,"date":"2012-02-09T19:44:45","date_gmt":"2012-02-10T01:44:45","guid":{"rendered":"http:\/\/xlfxs.com\/?p=278"},"modified":"2012-02-09T19:44:45","modified_gmt":"2012-02-10T01:44:45","slug":"convert-2-columns-table-into-column-row-table","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=278","title":{"rendered":"Convert 2-column into wide (column-row) table"},"content":{"rendered":"<p><span style=\"font-size: small;\">This Excel file will convert a table of two columns into a Column-Row table<br \/>\nUsing functions only and auto-updated once the Main table update<\/span><\/p>\n<p><span style=\"font-size: small;\">In another word, analyze the table into wider form<\/span><\/p>\n<p>I needed this one few days ago and you will need this one too.<\/p>\n<p>The main formula that you need to use is:<\/p>\n<p><!--more--><\/p>\n<pre>=IF(ROW()-6&gt;G$5,\"\",OFFSET($C$6,MATCH(G$6,$B:$B,0)-6+ROW()-7,0))<\/pre>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2012\/02\/ColsTable2RowTable.zip\"><img decoding=\"async\" class=\"aligncenter\" src=\"\/wp-content\/uploads\/2014\/12\/Download1.png\" alt=\"\" \/><\/a><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>This Excel file will convert a table of two columns into a Column-Row table Using functions only and auto-updated once the Main table update In another word, analyze the table into wider form I needed this one few days ago and you will need this one too. The main formula that you need to use&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=278\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Convert 2-column into wide (column-row) table&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":282,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,80,36,37,47,51,6],"tags":[],"class_list":["post-278","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","category-if","category-lookup_and_references","category-match","category-offset","category-row","category-standard_functions"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=278"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/278\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/282"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}