{"id":164,"date":"2012-02-05T14:42:06","date_gmt":"2012-02-05T20:42:06","guid":{"rendered":"http:\/\/xlfxs.com\/?p=164"},"modified":"2012-02-05T14:42:06","modified_gmt":"2012-02-05T20:42:06","slug":"insert-blank-rows-into-table-using-functions","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=164","title":{"rendered":"Insert Blank rows into table using functions"},"content":{"rendered":"<p><span style=\"font-size: small;\">Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank sheet to copy all values of that table into the new sheet<br \/>\nThen using Copy &gt; Paste Special to make them constants<br \/>\nThe new thing is that this is all done using only functions (Except the Copy and Paste for sure)<\/span><\/p>\n<p>Formula used:<\/p>\n<pre>=IF(ROW()\/$F$1=INT(ROW()\/$F$1),\"\",INDIRECT(\"Sheet1!\"&amp;CHAR(COLUMN()+64)&amp;INT(ROW()\/$F$1)-(INT(ROW()\/$F$1))*2+ROW()))<\/pre>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2012\/02\/InsertBlankFX.zip\"><img decoding=\"async\" class=\"aligncenter\" src=\"\/wp-content\/uploads\/2014\/12\/Download1.png\" alt=\"\" \/><\/a><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank sheet to copy all values of that table into the new sheet Then using Copy &gt; Paste Special to make them constants The new thing is that this is all&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=164\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Insert Blank rows into table using functions&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":167,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,72,3,80,85,86,36,51,6],"tags":[],"class_list":["post-164","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-char","category-column","category-formulas","category-if","category-indirect","category-int","category-lookup_and_references","category-row","category-standard_functions"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/164","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=164"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/164\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/167"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}