{"id":1178,"date":"2018-01-20T09:18:03","date_gmt":"2018-01-20T08:18:03","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=1178"},"modified":"2022-06-13T09:09:00","modified_gmt":"2022-06-13T07:09:00","slug":"popunjavanje-praznih-celija-tabele","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/popunjavanje-praznih-celija-tabele\/","title":{"rendered":"Filling blank cell tables"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/popunjavanje-praznih-celija-tabele\/#Upotreba_PowerQuery_od_verzije_2019_je_obavezna\" >Upotreba PowerQuery od verzije 2019 je obavezna<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/popunjavanje-praznih-celija-tabele\/#Popunjavanje_tabele\" >Popunjavanje tabele<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\nFilling blank cells in a table can be done using the <a href=\"http:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">PowerQuery<\/a> plug-in. As we see in the example in the following figure, often the same data is not repeated in the process of filling in the data table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1182\" src=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1.png\" alt=\"\" width=\"648\" height=\"654\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1.png 648w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1-350x353.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1-100x100.png 100w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1-150x150.png 150w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1-297x300.png 297w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery1-50x50.png 50w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/p>\n<p>If we would like to brew the data from this table, we would get an incorrect result. That is why it is necessary to fill all the cells in the first column, which can be very tiring by manual copying.<\/p>\n<p>Filling blank cells in the table will be done by calling the PowerQuery plugin that exists for versions 2010\/2013\/2016, as follows:<\/p>\n<ul>\n<li>First click on any cell of the table,<br \/>\nSecond, choose <strong>Data Tab<\/strong>,<br \/>\nThird, in the <strong>Get &amp; Transform<\/strong> section, choose <strong>From Table<\/strong> (circled with red).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1192\" src=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery2.png\" alt=\"\" width=\"1213\" height=\"674\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery2.png 1213w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery2-350x194.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery2-300x167.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery2-768x427.png 768w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery2-1024x569.png 1024w\" sizes=\"auto, (max-width: 1213px) 100vw, 1213px\" \/><\/p>\n<p>Filling blank cell tables<\/p>\n<p>When a new content window is opened as in the previous picture, select the head column whose cell we want to fill.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1194\" src=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery3.png\" alt=\"\" width=\"919\" height=\"681\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery3.png 919w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery3-350x259.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery3-300x222.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery3-768x569.png 768w\" sizes=\"auto, (max-width: 919px) 100vw, 919px\" \/><\/p>\n<p>Now we can select the <strong>Transform Tab<\/strong> and in the <strong>Column<\/strong> section, choose the <strong>Fill<\/strong> function that offers the variants downwards (<strong>Down<\/strong>) and up (<strong>Up<\/strong>).<\/p>\n<p>In this example, we select the <strong>Down<\/strong> option, obtaining the result as in the following figure.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1201\" src=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery4.png\" alt=\"\" width=\"502\" height=\"617\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery4.png 502w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery4-350x430.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery4-244x300.png 244w\" sizes=\"auto, (max-width: 502px) 100vw, 502px\" \/><\/p>\n<p>End for end up go to Excel with button\u00a0<strong>Close &amp; Load<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1210\" src=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery5.png\" alt=\"\" width=\"527\" height=\"322\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery5.png 527w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery5-350x214.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2018\/01\/powerquery5-300x183.png 300w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><\/p>\n<p><span style=\"color: #ffffff;\">Popunja.vanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u eksel dodatka <a style=\"color: #ffffff;\" href=\"http:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">PowerQuery<\/a> .\u00a0 Kao \u0161to mo\u017eemo videti u primeru na slede\u0107oj slici, \u010desto puta nam se u procesu popunjavanj.a tabele podacima ne pon.vljaju isti podaci.\u00a0Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u eksel dodatka <a style=\"color: #ffffff;\" href=\"http:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">PowerQuery<\/a> .\u00a0 Kao \u0161to mo\u017eem.o videti u primeru na slede\u0107oj slici, \u010desto puta nam se u procesu .popunjavanja tabele po.dacima ne ponavljaju isti podaci.\u00a0Popunj.avanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pom.o\u0107u eksel dodatka <a style=\"color: #ffffff;\" href=\"http:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">PowerQuery<\/a> .\u00a0 Kao \u0161to mo\u017eemo videti u primeru na slede\u0107oj slici, \u010desto puta nam se u procesu popunjav.anja tabele podacima .ne ponav.ljaju isti podaci.<\/span>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;1178&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Filling blank cell tables&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Filling blank cells in a table can be done using the PowerQuery plug-in. As we see in the example in<\/p>\n","protected":false},"author":1,"featured_media":2154,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,40],"tags":[],"class_list":["post-1178","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-excel","category-powerquery"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Popunjavanje praznih \u0107elija tabele<\/title>\n<meta name=\"description\" content=\"Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u excel dodatka PowerQuery opcijom fill down ako se ponavljaju isti podaci.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Popunjavanje praznih \u0107elija tabele\" \/>\n<meta property=\"og:description\" content=\"Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u excel dodatka PowerQuery opcijom fill down ako se ponavljaju isti podaci.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-20T08:18:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-13T07:09:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png\" \/>\n\t<meta property=\"og:image:width\" content=\"209\" \/>\n\t<meta property=\"og:image:height\" content=\"140\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Filling blank cell tables\",\"datePublished\":\"2018-01-20T08:18:03+00:00\",\"dateModified\":\"2022-06-13T07:09:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/\"},\"wordCount\":647,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/power-e1624192014714.png\",\"articleSection\":[\"Power Excel\",\"\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/\",\"name\":\"Popunjavanje praznih \u0107elija tabele\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/power-e1624192014714.png\",\"datePublished\":\"2018-01-20T08:18:03+00:00\",\"dateModified\":\"2022-06-13T07:09:00+00:00\",\"description\":\"Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u excel dodatka PowerQuery opcijom fill down ako se ponavljaju isti podaci.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/power-e1624192014714.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/power-e1624192014714.png\",\"width\":209,\"height\":140},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/popunjavanje-praznih-celija-tabele\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Popunjavanje praznih \u0107elija tabele\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Popunjavanje praznih \u0107elija tabele","description":"Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u excel dodatka PowerQuery opcijom fill down ako se ponavljaju isti podaci.","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:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/","og_locale":"en_US","og_type":"article","og_title":"Popunjavanje praznih \u0107elija tabele","og_description":"Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u excel dodatka PowerQuery opcijom fill down ako se ponavljaju isti podaci.","og_url":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2018-01-20T08:18:03+00:00","article_modified_time":"2022-06-13T07:09:00+00:00","og_image":[{"width":209,"height":140,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Filling blank cell tables","datePublished":"2018-01-20T08:18:03+00:00","dateModified":"2022-06-13T07:09:00+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/"},"wordCount":647,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","articleSection":["Power Excel",""],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/","url":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/","name":"Popunjavanje praznih \u0107elija tabele","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","datePublished":"2018-01-20T08:18:03+00:00","dateModified":"2022-06-13T07:09:00+00:00","description":"Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u excel dodatka PowerQuery opcijom fill down ako se ponavljaju isti podaci.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png","width":209,"height":140},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/popunjavanje-praznih-celija-tabele\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Popunjavanje praznih \u0107elija tabele"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/1178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=1178"}],"version-history":[{"count":17,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/1178\/revisions"}],"predecessor-version":[{"id":3242,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/1178\/revisions\/3242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/2154"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=1178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=1178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=1178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}