{"id":333,"date":"2012-03-19T16:11:55","date_gmt":"2012-03-19T22:11:55","guid":{"rendered":"http:\/\/xlfxs.com\/?p=333"},"modified":"2012-03-19T16:11:55","modified_gmt":"2012-03-19T22:11:55","slug":"fx-to-cut-long-column-into-two-columns","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=333","title":{"rendered":"Fx to cut long column into two columns"},"content":{"rendered":"<p><span style=\"font-size: small;\">Convert one long column into two<br \/>\nThis set of formulas will get the items after row 45 (for example) from column A into the column B starting from B1 to have two 45-rows next to each other instead of one 90-rows column<\/span><\/p>\n<p>This was the answer for this question<br \/>\nYahoo! Answers question <a href=\"http:\/\/answers.yahoo.com\/question\/index?qid=20081225182043AAc7ZEB\" target=\"_BLANK\" rel=\"noopener\">http:\/\/answers.yahoo.com\/question\/index?qid=20081225182043AAc7ZEB<\/a><\/p>\n<p><span style=\"font-size: small;\">Show two columns in one page as four columns using functions only. This will help you to show the next x number of rows for a certain column to the next of the first one to reduce the number of pages to print.<\/span><\/p>\n<p><!--more--><\/p>\n<p>Can work also to convert into 3 columns out of 1, etc<\/p>\n<p>Use this formula to grap the first column<br \/>\n<code>=OFFSET(OneCol!$B$1,((INT((ROW()-1)\/$A$1)+1)-1)*$A$1+ROW()-1,0)<\/code><br \/>\nAnd use this one to grap the second column<br \/>\n<code>=OFFSET(OneCol!$B$1,((INT((ROW()-1)\/$A$1)+1))*$A$1+ROW()-1,0)<\/code><br \/>\nAgain, all these formulas are linked to cell A1<\/p>\n\n<p>&nbsp;<\/p>\n<div class=\"row\">\n<div class=\"col-lg-6 col-md-6 col-sm-6 text-right\"><a class=\"btn btn-primary btn-lg\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2012\/03\/Zip_0085.zip\"><i class=\"fa fa-download\"><\/i> Download spreadsheet<\/a><\/div>\n<div class=\"col-lg-6 col-md-6 col-sm-6\"><a class=\"btn btn-primary btn-lg\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO18tMC2TRYKc-r2McPg\"><i class=\"fa fa-cloud\"><\/i> Excel Online version<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Convert one long column into two This set of formulas will get the items after row 45 (for example) from column A into the column B starting from B1 to have two 45-rows next to each other instead of one 90-rows column This was the answer for this question Yahoo! Answers question http:\/\/answers.yahoo.com\/question\/index?qid=20081225182043AAc7ZEB Show two&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=333\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Fx to cut long column into two columns&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":338,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,86,36,47,51,6],"tags":[],"class_list":["post-333","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","category-int","category-lookup_and_references","category-offset","category-row","category-standard_functions"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/333","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=333"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/333\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/338"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}