{"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\/popunjavanje-praznih-celija-tabele\/","title":{"rendered":"[:sr]Popunjavanje praznih \u0107elija tabele[:en]Filling blank cell tables[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 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\">[:sr]Sadr\u017eaj[:en] 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\/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\/popunjavanje-praznih-celija-tabele\/#Popunjavanje_tabele\" >Popunjavanje tabele<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n[:sr]\n<h2><span class=\"ez-toc-section\" id=\"Upotreba_PowerQuery_od_verzije_2019_je_obavezna\"><\/span>Upotreba PowerQuery od verzije 2019 je obavezna<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u eksel dodatka <a href=\"https:\/\/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 popunjavanja tabele podacima ne ponavljaju isti podaci.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1182\" src=\"https:\/\/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>Ako bi \u017eeleli da pivotiramo podatke iz ovakve tabele dobili bi smo neta\u010dan reziltat. Zato je neophodno popuniti sve \u0107elije u prvoj koloni, \u0161to ru\u010dnim kopiranjem mo\u017ee postati veoma zamorno.<\/p>\n<p>Popunjavanje praznih \u0107elija \u0107emo uraditi pozivanjem <a href=\"https:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">PowerQuery<\/a> dodatka koji postoji za verzije 2010\/2013\/2016, na slede\u0107i na\u010din:<\/p>\n<ul>\n<li>Prvo kliknimo na bilo koju \u0107eliju tabele,<\/li>\n<li>Drugo, Izaberimo <strong>Data Tab<\/strong>,<\/li>\n<li>Tre\u0107e, u odeljku <strong>Get&amp;Transform<\/strong> odaberimo opciju <strong>From Table<\/strong> (zaokru\u017eeno crvenom linijom).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1192\" src=\"https:\/\/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<h3><span class=\"ez-toc-section\" id=\"Popunjavanje_tabele\"><\/span>Popunjavanje tabele<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kada nam se otvori novi prozor sa sadr\u017eajem kao na prethodnoj slici, selektujmo kolonu \u010dije \u0107elije \u017eelimo popuniti.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1194\" src=\"https:\/\/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>Sada mo\u017eemo odabrati <strong>Transform Tab<\/strong> i u odeljku Column, izabrati funkciju<strong> Fill<\/strong> koja nam nudi varijante na dole (<strong>Down<\/strong>) i na gore (Up).<\/p>\n<p>U datom primeru izabiramo opciju Down, dobijaju\u0107i rezultat kao na slede\u0107oj slici.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1201\" src=\"https:\/\/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>I na kraju vratite se u Excel izborom <strong>Close &amp; Load<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1210\" src=\"https:\/\/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: #000000;\">Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u eksel dodatka <a style=\"color: #000000;\" href=\"https:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">PowerQuery<\/a> .\u00a0 Kao \u0161to mo\u017eemo videti u prim.eru na slede\u0107oj slici, \u010desto puta nam se u procesu popunjavanja tabele podacima ne ponavljaju isti podaci.\u00a0Popunjavanje praznih \u0107elija tabele mogu\u0107e je iz.vr\u0161iti pomo\u0107u eksel dodatka <a style=\"color: #000000;\" href=\"https:\/\/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 pop.unjavanja tabele podacima ne ponavljaju isti podaci.\u00a0Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u eksel dodatka <a style=\"color: #000000;\" href=\"https:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">PowerQuery<\/a> .\u00a0 Ka.o \u0161to mo\u017eemo videti u primeru na sled.e\u0107oj slici, \u010desto puta nam se u procesu popunjavanja tabele podacima ne ponavljaju isti podaci.<\/span>[:en]Filling blank cells in a table can be done using the <a href=\"https:\/\/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=\"https:\/\/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=\"https:\/\/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=\"https:\/\/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=\"https:\/\/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=\"https:\/\/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=\"https:\/\/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=\"https:\/\/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=\"https:\/\/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;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Popunjavanje praznih \u0107elija tabele[:en]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\">[:sr] Ocenite [:en]Rate this [:]post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr] Upotreba PowerQuery od verzije 2019 je obavezna Popunjavanje praznih \u0107elija tabele mogu\u0107e je izvr\u0161iti pomo\u0107u eksel dodatka PowerQuery .\u00a0<\/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 v28.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=\"Kalkulacija u osnovi svega!\" \/>\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\":\"[:sr]Popunjavanje praznih \u0107elija tabele[:en]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\",\"PowerQuery\"],\"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\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"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":"Kalkulacija u osnovi svega!","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":"[:sr]Popunjavanje praznih \u0107elija tabele[:en]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","PowerQuery"],"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":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","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\/wp-json\/wp\/v2\/posts\/1178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1178"}],"version-history":[{"count":17,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1178\/revisions"}],"predecessor-version":[{"id":3242,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/1178\/revisions\/3242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/2154"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}