Power Query Archives - Excel Champs

How to Merge [Combine] Multiple Excel FILES into ONE WORKBOOK

If you ask people who work with data, you will get to know that combining Excel files or merging workbooks is a part of their daily work.Agree?A simple an example:

How to Perform VLOOKUP in Power Query in Excel

VLOOKUP is one of the most popular Excel functions and there’s no doubt about it. You know this from the very beginning of your Excel journey. But today I have

How to Unpivot Data in Excel using Power Query

Data in a crosstab form is good to use as a report because it’s easily understandable. But the problem occurs when you need to use it further. In this situation, you need

img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}@media (max-width:768px){}body{background-color:#efefef;color:#3a3a3a;}a{color:#4242ed;}a:hover,a:focus,a:active{color:#000;}body .grid-container{max-width:1300px;}.wp-block-group__inner-container{max-width:1300px;margin-left:auto;margin-right:auto;}.site-header .header-image{width:250px;}.navigation-search{position:absolute;left:-99999px;pointer-events:none;visibility:hidden;z-index:20;width:100%;top:0;transition:opacity 100ms ease-in-out;opacity:0;}.navigation-search.nav-search-active{left:0;right:0;pointer-events:auto;visibility:visible;opacity:1;}.navigation-search input[type="search"]{outline:0;border:0;vertical-align:bottom;line-height:1;opacity:.9;width:100%;z-index:20;border-radius:0;-webkit-appearance:none;height:60px;}.navigation-search input::-ms-clear{display:none;width:0;height:0;}.navigation-search input::-ms-reveal{display:none;width:0;height:0;}.navigation-search input::-webkit-search-decoration,.navigation-search input::-webkit-search-cancel-button,.navigation-search input::-webkit-search-results-button,.navigation-search input::-webkit-search-results-decoration{display:none;}.main-navigation li.search-item{z-index:21;}li.search-item.active{transition:opacity 100ms ease-in-out;}.nav-left-sidebar .main-navigation li.search-item.active,.nav-right-sidebar .main-navigation li.search-item.active{width:auto;display:inline-block;float:right;}.gen-sidebar-nav .navigation-search{top:auto;bottom:0;}body,button,input,select,textarea{font-family:Segoe UI,Helvetica Neue,Helvetica,sans-serif;font-size:20px;}body{line-height:2;}p{margin-bottom:1.7em;}.entry-content > [class*="wp-block-"]:not(:last-child){margin-bottom:1.7em;}.main-title{font-family:Segoe UI,Helvetica Neue,Helvetica,sans-serif;font-weight:normal;font-size:28px;}.main-navigation a,.menu-toggle{font-family:Verdana,Geneva,sans-serif;font-weight:bold;font-size:17px;}.main-navigation .main-nav ul ul li a{font-size:14px;}.widget-title{font-family:Verdana,Geneva,sans-serif;}.sidebar .widget,.footer-widgets .widget{font-size:17px;}h1{font-family:"Montserrat",sans-serif;font-weight:400;font-size:50px;margin-bottom:5px;}h2{font-family:"Montserrat",sans-serif;font-weight:400;font-size:40px;margin-bottom:5px;}h3{font-family:"Montserrat",sans-serif;font-weight:400;font-size:30px;line-height:1.5em;margin-bottom:5px;}h4{font-family:Georgia,Times New Roman,Times,serif;font-weight:900;font-size:20px;line-height:1.6em;}h5{font-size:inherit;line-height:1em;}.site-info{font-family:Segoe UI,Helvetica Neue,Helvetica,sans-serif;font-size:17px;}@media (max-width:768px){.main-title{font-size:30px;}h1{font-size:30px;}h2{font-size:25px;}}.top-bar{background-color:#636363;color:#fff;}.top-bar a{color:#fff;}.top-bar a:hover{color:#303030;}.site-header{background-color:#49d295;color:#3a3a3a;}.site-header a{color:#3a3a3a;}.main-title a,.main-title a:hover{color:#222;}.site-description{color:#757575;}.mobile-menu-control-wrapper .menu-toggle,.mobile-menu-control-wrapper .menu-toggle:hover,.mobile-menu-control-wrapper .menu-toggle:focus,.has-inline-mobile-toggle #site-navigation.toggled{background-color:rgba(0,0,0,.02);}.main-navigation,.main-navigation ul ul{background-color:#49d295;}.main-navigation .main-nav ul li a,.menu-toggle,.main-navigation .menu-bar-items{color:#3a3a3a;}.main-navigation .main-nav ul li:hover > a,.main-navigation .main-nav ul li:focus > a,.main-navigation .main-nav ul li.sfHover > a,.main-navigation .menu-bar-item:hover > a,.main-navigation .menu-bar-item.sfHover > a{color:#3a3a3a;background-color:#49d295;}button.menu-toggle:hover,button.menu-toggle:focus,.main-navigation .mobile-bar-items a,.main-navigation .mobile-bar-items a:hover,.main-navigation .mobile-bar-items a:focus{color:#3a3a3a;}.main-navigation .main-nav ul li[class*="current-menu-"] > a{color:#3a3a3a;background-color:#49d295;}.main-navigation .main-nav ul li[class*="current-menu-"] > a:hover,.main-navigation .main-nav ul li[class*="current-menu-"].sfHover > a{color:#3a3a3a;background-color:#49d295;}.navigation-search input[type="search"],.navigation-search input[type="search"]:active,.navigation-search input[type="search"]:focus,.main-navigation .main-nav ul li.search-item.active > a,.main-navigation .menu-bar-items .search-item.active > a{color:#3a3a3a;background-color:#49d295;}.main-navigation ul ul{background-color:#49d295;}.main-navigation .main-nav ul ul li a{color:#3a3a3a;}.main-navigation .main-nav ul ul li:hover > a,.main-navigation .main-nav ul ul li:focus > a,.main-navigation .main-nav ul ul li.sfHover > a{color:#3a3a3a;background-color:#49d295;}.main-navigation .main-nav ul ul li[class*="current-menu-"] > a{color:#3a3a3a;background-color:#49d295;}.main-navigation .main-nav ul ul li[class*="current-menu-"] > a:hover,.main-navigation .main-nav ul ul li[class*="current-menu-"].sfHover > a{color:#3a3a3a;background-color:#49d295;}.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.one-container .container,.separate-containers .paging-navigation,.inside-page-header{background-color:#fff;}.entry-meta{color:#595959;}.entry-meta a{color:#595959;}.entry-meta a:hover{color:#1e73be;}h1{color:#3a3a3a;}h2{color:#3a3a3a;}h3{color:#a0a0a0;}h4{color:#3a3a3a;}.sidebar .widget{background-color:#fff;}.sidebar .widget .widget-title{color:#000;}.footer-widgets{color:#0a0a0a;background-color:#1abc9c;}.footer-widgets a{color:#0a0a0a;}.footer-widgets a:hover{color:#0a0a0a;}.footer-widgets .widget-title{color:#000;}.site-info{color:#0a0a0a;background-color:#1abc9c;}.site-info a{color:#0a0a0a;}.site-info a:hover{color:#0a0a0a;}.footer-bar .widget_nav_menu .current-menu-item a{color:#0a0a0a;}input[type="text"],input[type="email"],input[type="url"],input[type="password"],input[type="search"],input[type="tel"],input[type="number"],textarea,select{color:#666;background-color:#fafafa;border-color:#ccc;}input[type="text"]:focus,input[type="email"]:focus,input[type="url"]:focus,input[type="password"]:focus,input[type="search"]:focus,input[type="tel"]:focus,input[type="number"]:focus,textarea:focus,select:focus{color:#666;background-color:#fff;border-color:#bfbfbf;}button,html input[type="button"],input[type="reset"],input[type="submit"],a.button,a.wp-block-button__link:not(.has-background){color:#fff;background-color:#666;}button:hover,html input[type="button"]:hover,input[type="reset"]:hover,input[type="submit"]:hover,a.button:hover,button:focus,html input[type="button"]:focus,input[type="reset"]:focus,input[type="submit"]:focus,a.button:focus,a.wp-block-button__link:not(.has-background):active,a.wp-block-button__link:not(.has-background):focus,a.wp-block-button__link:not(.has-background):hover{color:#fff;background-color:#3f3f3f;}a.generate-back-to-top{background-color:#abb8bf;color:#0a0a0a;}a.generate-back-to-top:hover,a.generate-back-to-top:focus{background-color:#abb8bf;color:#0a0a0a;}@media (max-width: 768px){.main-navigation .menu-bar-item:hover > a,.main-navigation .menu-bar-item.sfHover > a{background:none;color:#3a3a3a;}}.inside-top-bar{padding:10px;}.inside-header{padding:10px 40px 10px 40px;}.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.separate-containers .paging-navigation,.one-container .site-content,.inside-page-header{padding:20px 40px 40px 40px;}.site-main .wp-block-group__inner-container{padding:20px 40px 40px 40px;}.entry-content .alignwide,body:not(.no-sidebar) .entry-content .alignfull{margin-left:-40px;width:calc(100% + 80px);max-width:calc(100% + 80px);}.separate-containers .widget,.separate-containers .site-main > *,.separate-containers .page-header,.widget-area .main-navigation{margin-bottom:1px;}.separate-containers .site-main{margin:1px;}.both-right.separate-containers .inside-left-sidebar{margin-right:0px;}.both-right.separate-containers .inside-right-sidebar{margin-left:0px;}.both-left.separate-containers .inside-left-sidebar{margin-right:0px;}.both-left.separate-containers .inside-right-sidebar{margin-left:0px;}.separate-containers .page-header-image,.separate-containers .page-header-contained,.separate-containers .page-header-image-single,.separate-containers .page-header-content-single{margin-top:1px;}.separate-containers .inside-right-sidebar,.separate-containers .inside-left-sidebar{margin-top:1px;margin-bottom:1px;}.main-navigation .main-nav ul li a,.menu-toggle,.main-navigation .mobile-bar-items a{padding-left:25px;padding-right:25px;line-height:40px;}.main-navigation .main-nav ul ul li a{padding:10px 25px 10px 25px;}.navigation-search input[type="search"]{height:40px;}.rtl .menu-item-has-children .dropdown-menu-toggle{padding-left:25px;}.menu-item-has-children .dropdown-menu-toggle{padding-right:25px;}.rtl .main-navigation .main-nav ul li.menu-item-has-children > a{padding-right:25px;}.widget-area .widget{padding:0px;}.footer-widgets{padding:20px 40px 20px 40px;}.site-info{padding:20px;}@media (max-width:768px){.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.separate-containers .paging-navigation,.one-container .site-content,.inside-page-header{padding:30px;}.site-main .wp-block-group__inner-container{padding:30px;}.site-info{padding-right:10px;padding-left:10px;}.entry-content .alignwide,body:not(.no-sidebar) .entry-content .alignfull{margin-left:-30px;width:calc(100% + 60px);max-width:calc(100% + 60px);}}@media (max-width: 768px){.main-navigation .menu-toggle,.main-navigation .mobile-bar-items,.sidebar-nav-mobile:not(#sticky-placeholder){display:block;}.main-navigation ul,.gen-sidebar-nav{display:none;}[class*="nav-float-"] .site-header .inside-header > *{float:none;clear:both;}}.dynamic-author-image-rounded{border-radius:100%;}.dynamic-featured-image,.dynamic-author-image{vertical-align:middle;}.one-container.blog .dynamic-content-template:not(:last-child),.one-container.archive .dynamic-content-template:not(:last-child){padding-bottom:0px;}.dynamic-entry-excerpt > p:last-child{margin-bottom:0px;}h2.entry-title{line-height:1.5em;}.post-image:not(:first-child),.page-content:not(:first-child),.entry-content:not(:first-child),.entry-summary:not(:first-child),footer.entry-meta{margin-top:0em;}.post-image-above-header .inside-article div.featured-image,.post-image-above-header .inside-article div.post-image{margin-bottom:0em;}@font-face{font-family:"FontAwesome";src:url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-brands-400.eot"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-brands-400.eot#iefix") format("embedded-opentype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-brands-400.woff2") format("woff2"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-brands-400.woff") format("woff"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-brands-400.ttf") format("truetype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/releases/v5.15.4/webfonts/fa-brands-400.svg#fontawesome") format("svg");font-display:swap;}@font-face{font-family:"FontAwesome";src:url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-solid-900.eot"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-solid-900.eot#iefix") format("embedded-opentype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-solid-900.woff2") format("woff2"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-solid-900.woff") format("woff"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-solid-900.ttf") format("truetype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/releases/v5.15.4/webfonts/fa-solid-900.svg#fontawesome") format("svg");font-display:swap;}@font-face{font-family:"FontAwesome";src:url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-regular-400.eot"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-regular-400.eot#iefix") format("embedded-opentype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-regular-400.woff2") format("woff2"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-regular-400.woff") format("woff"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.4/webfonts/fa-regular-400.ttf") format("truetype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/releases/v5.15.4/webfonts/fa-regular-400.svg#fontawesome") format("svg");unicode-range:U+F004-F005,U+F007,U+F017,U+F022,U+F024,U+F02E,U+F03E,U+F044,U+F057-F059,U+F06E,U+F070,U+F075,U+F07B-F07C,U+F080,U+F086,U+F089,U+F094,U+F09D,U+F0A0,U+F0A4-F0A7,U+F0C5,U+F0C7-F0C8,U+F0E0,U+F0EB,U+F0F3,U+F0F8,U+F0FE,U+F111,U+F118-F11A,U+F11C,U+F133,U+F144,U+F146,U+F14A,U+F14D-F14E,U+F150-F152,U+F15B-F15C,U+F164-F165,U+F185-F186,U+F191-F192,U+F1AD,U+F1C1-F1C9,U+F1CD,U+F1D8,U+F1E3,U+F1EA,U+F1F6,U+F1F9,U+F20A,U+F247-F249,U+F24D,U+F254-F25B,U+F25D,U+F267,U+F271-F274,U+F279,U+F28B,U+F28D,U+F2B5-F2B6,U+F2B9,U+F2BB,U+F2BD,U+F2C1-F2C2,U+F2D0,U+F2D2,U+F2DC,U+F2ED,U+F328,U+F358-F35B,U+F3A5,U+F3D1,U+F410,U+F4AD;font-display:swap;}:not(#tve) .ttfm1{font-family:"Montserrat" !important;font-weight:400 !important;}.ttfm1 input,.ttfm1 select,.ttfm1 textarea,.ttfm1 button{font-family:"Montserrat" !important;font-weight:400 !important;}:not(#tve) .ttfm1.bold_text,.ttfm1 .bold_text,.ttfm1 b,.ttfm1 strong{font-weight:500 !important;}.ttfm1.bold_text,.ttfm1 .bold_text,.ttfm1 b,.ttfm1 strong input,.ttfm1.bold_text,.ttfm1 .bold_text,.ttfm1 b,.ttfm1 strong select,.ttfm1.bold_text,.ttfm1 .bold_text,.ttfm1 b,.ttfm1 strong textarea,.ttfm1.bold_text,.ttfm1 .bold_text,.ttfm1 b,.ttfm1 strong button{font-weight:500 !important;}:root{--tcb-color-0:#000;--tcb-color-0-h:0;--tcb-color-0-s:0%;--tcb-color-0-l:0%;--tcb-color-0-a:1;--tcb-background-author-image:url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/desktop/optimized/avatar/093252b6d8e64437634afb3f096df10d.8177cfa896d1ccfc2735d2b5b1569851");--tcb-background-user-image:url("");--tcb-background-featured-image-thumbnail:url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/wp-content/uploads/2019/01/combine-multiple-files-into-one-workbook-featured-image.png");}@import url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/desktop/optimized/nitro-min-b6ada65d4102777c6f8060b88a7eb7c1.css");@media (min-width:300px){:not(#tve) [data-css="tve-u-1680cf41cdb"]{color:#000 !important;}[data-css="tve-u-1680cf4c0e9"]{margin-top:0px !important;}[data-css="tve-u-1680cf4c0e9"] .tve_faq:hover{background:#fff;}:not(#tve) [data-css="tve-u-1680cf6fc40"]{color:#000 !important;}:not(#tve) [data-css="tve-u-1680cf72a1d"]{color:#000 !important;}[data-css="tve-u-1680d2d7dcc"]{margin-bottom:10px !important;margin-top:0px !important;}[data-css="tve-u-1680d2d8145"]{padding-bottom:0px !important;padding-top:0px !important;}[data-css="tve-u-16812ca59c3"]{color:#f00 !important;}[data-css="tve-u-1681cc41006"]{width:80%;float:none;margin-top:0px !important;margin-left:auto !important;margin-right:auto !important;}[data-css="tve-u-1681d129236"]{width:80%;float:none;margin:0px auto !important;}[data-css="tve-u-1681d25d8f5"]{width:55%;float:none;margin:0px auto !important;}[data-css="tve-u-1681d2fb86c"]{color:#000 !important;}[data-css="tve-u-1681d2fe1f7"]{color:#000 !important;}[data-css="tve-u-1681d302532"]{color:#000 !important;}[data-css="tve-u-1681d306219"]{color:#000 !important;}[data-css="tve-u-1681d3092d7"]{color:#000 !important;}[data-css="tve-u-1681d345173"]{color:#000 !important;}[data-css="tve-u-1681d34bff8"]{color:#000 !important;}[data-css="tve-u-1681d8caf5f"]{width:60%;float:none;margin:0px auto !important;}[data-css="tve-u-1681d8fad8d"]{width:60%;float:none;margin:0px auto 20px !important;}[data-css="tve-u-1682215f9f2"]{width:45%;float:none;margin:0px auto !important;}[data-css="tve-u-1682216fb46"]{color:#000 !important;}[data-css="tve-u-168222b4b46"]{width:50%;float:none;margin-left:auto !important;margin-right:auto !important;margin-top:0px !important;}[data-css="tve-u-16822638a08"]{width:50%;float:none;margin:0px auto !important;}[data-css="tve-u-16822bfcb91"]{width:100%;float:none;margin:0px auto !important;}[data-css="tve-u-16822c0f14e"]{color:#000 !important;}[data-css="tve-u-16822c62f1b"]{width:45%;float:none;margin-left:auto !important;margin-right:auto !important;margin-top:0px !important;}[data-css="tve-u-16822c985a0"]{color:#000 !important;}[data-css="tve-u-16822cbbf2d"]{width:60%;float:none;margin-top:0px !important;margin-left:auto !important;margin-right:auto !important;}[data-css="tve-u-16822ff480f"]{width:100%;float:none;margin-left:auto !important;margin-right:auto !important;margin-top:0px !important;}:not(#tve) [data-css="tve-u-16826cfb974"]{color:#ea493f !important;}[data-css="tve-u-16826cfed9e"]{color:#000 !important;background-color:#ff0 !important;}[data-css="tve-u-16826d1fc49"]{width:40%;float:none;margin-top:0px !important;margin-left:auto !important;margin-right:auto !important;}[data-css="tve-u-16826dddcb4"]{width:40%;float:none;margin-left:auto !important;margin-right:auto !important;margin-top:0px !important;}[data-css="tve-u-16826e57050"]{width:70%;float:none;margin-left:auto !important;margin-right:auto !important;margin-top:0px !important;}[data-css="tve-u-16826ecdf7d"]{width:60%;float:none;margin-top:0px !important;margin-left:auto !important;margin-right:auto !important;}:not(#tve) [data-css="tve-u-168272deb94"]{font-size:24px !important;color:#000 !important;}:not(#tve) [data-css="tve-u-1682754fcea"]{color:#ea493f !important;}:not(#tve) [data-css="tve-u-16f8109a50a"]{font-size:13px !important;}[data-css="tve-u-16f8109a50c"]{width:86px;margin-bottom:5px !important;margin-top:5px !important;}[data-css="tve-u-16f8109a50e"]{margin-top:0px;margin-left:0px;}[data-css="tve-u-16f8109a50f"]{float:left;z-index:3;position:relative;display:block;max-width:100%;width:100%;margin-top:0px !important;margin-bottom:10px !important;}[data-css="tve-u-16f8109a511"]::after{clear:both;}:not(#tve) [data-css="tve-u-16f8109a50f"] .tcb-button-link{line-height:1.2em;font-size:18px;}[data-css="tve-u-16f8109a50f"] .tcb-button-link{padding-right:15px;padding-left:15px;border-radius:3px;overflow:hidden;border-color:#b5b5b5;padding-top:12px !important;padding-bottom:12px !important;background-color:#0077b5 !important;background-image:none !important;}[data-css="tve-u-16f8109a50f"] .tcb-button-link.nitro-lazy{background-image:none !important;}[data-css="tve-u-16f8109a513"] p{padding:0px 0px 7px !important;margin:0px !important;}:not(#tve) [data-css="tve-u-16f8109a515"]{--g-regular-weight:400;--g-bold-weight:700;padding-bottom:0px !important;margin-bottom:0px !important;font-family:Montserrat !important;font-weight:var(--g-regular-weight,normal) !important;}:not(#tve) [data-css="tve-u-16f8109a515"] strong{font-weight:700 !important;}[data-css="tve-u-16f8109a516"]{border-top:none !important;background-color:#e1eef3 !important;}[data-css="tve-u-16f8109a518"]{max-width:52.6%;}[data-css="tve-u-16f8109a51a"]{max-width:47.4%;}[data-css="tve-u-16f8109a51b"]{float:left;z-index:3;position:relative;display:block;max-width:100%;width:100%;margin-top:0px !important;margin-bottom:10px !important;}:not(#tve) [data-css="tve-u-16f8109a51b"] .tcb-button-link{line-height:1.2em;font-size:18px;}[data-css="tve-u-16f8109a51b"] .tcb-button-link{padding-right:15px;padding-left:15px;border-radius:3px;overflow:hidden;padding-top:12px !important;padding-bottom:12px !important;background-color:#f00 !important;}[data-css="tve-u-16f8109a51f"] > .tcb-flex-col{padding-left:5px;}[data-css="tve-u-16f8109a51f"]{margin-left:-5px;flex-flow:row wrap !important;padding-bottom:0px !important;padding-top:10px !important;}[data-css="tve-u-16f8109a51f"] > .tcb-flex-col > .tcb-col{justify-content:center;}[data-css="tve-u-16f8109a522"]{float:none;margin:0px auto !important;}[data-css="tve-u-16f8109a523"]{margin-bottom:0px !important;padding-top:40px !important;margin-top:0px !important;padding-bottom:40px !important;}[data-css="tve-u-16f8109a525"]{height:30px;top:0px;transform:rotate(180deg);}[data-css="tve-u-16f8109a527"]{height:30px;bottom:0px;fill:#fff;}[data-css="tve-u-16f8109a51f"] .tcb-flex-col{flex-basis:250px !important;}[data-css="tve-u-172accadc31"]{margin-top:0px !important;margin-bottom:35px !important;}:not(#tve) [data-css="tve-u-172accb950a"] >:first-child{color:#f00;}[data-css="tve-u-172accfc3fc"]{margin-top:0px !important;}:not(#tve) [data-css="tve-u-172ae599e31"]{font-weight:var(--g-bold-weight,bold) !important;}:not(#tve) [data-css="tve-u-172ae5ac7aa"]{font-weight:var(--g-regular-weight,normal) !important;}}@import url("//fonts.googleapis.com/css?family=Montserrat:400,900,700,800,500&subset=latin");@media (min-width:300px){[data-css="tve-u-164d1227f6b"]{width:331px;float:none;margin:0px auto 35px !important;}[data-css="tve-u-164d120ef87"]{width:615px;float:none;margin:0px auto 35px !important;}:not(#tve) [data-css="tve-u-164d0d0f6c1"]{color:#f00 !important;}[data-css="tve-u-164d0c9617e"]{margin-top:0px !important;}[data-css="tve-u-164d0c9617e"] .tve_social_items{font-size:18px !important;}[data-css="tve-u-164da830fa2"]{width:197px;float:none;margin:0px auto !important;}[data-css="tve-u-164da8639c5"]{width:316px;float:none;margin:0px auto !important;}[data-css="tve-u-164da88e00b"]{width:232px;float:none;margin:0px auto !important;}[data-css="tve-u-164dad2fa59"]{width:354px;float:none;margin:0px auto !important;}[data-css="tve-u-164dad59b81"]{width:651px;float:none;margin:0px auto !important;}[data-css="tve-u-164dad672ab"]{width:668px;float:none;margin:0px auto !important;}[data-css="tve-u-164dad6bf46"]{width:417px;float:none;margin:0px auto !important;}[data-css="tve-u-164dad88641"]{width:504px;float:none;margin:0px auto !important;}[data-css="tve-u-164dad92c7e"]{width:425px;float:none;margin:0px auto 20px !important;}[data-css="tve-u-16e82fd5fcd"] .tve_sep{background-image:url("data:image/svg+xml;charset=utf8,%3Csvg version=\'1.1\' xmlns=\'http://www.w3.org/2000/svg\' xmlns:xlink=\'http://www.w3.org/1999/xlink\' x=\'0px\' y=\'0px\' viewBox=\'0 0 9 3\' style=\'enable-background:new 0 0 9 3;\' xml:space=\'preserve\'%3E%3Crect x=\'2\' y=\'1\' fill=\'rgb(66,66,66)\' width=\'5\' height=\'1\'/%3E%3C/svg%3E");background-size:1px 1px;height:1px !important;}[data-css="tve-u-16e82fd5fcd"] .tve_sep.nitro-lazy{background-image:none !important;}:not(#tve) [data-css="tve-u-16f81145c3a"]{font-size:13px !important;}[data-css="tve-u-16f81145c3c"]{width:86px;margin-bottom:5px !important;margin-top:5px !important;}[data-css="tve-u-16f81145c3d"]{margin-top:0px;margin-left:0px;}[data-css="tve-u-16f81145c3f"]{float:left;z-index:3;position:relative;display:block;max-width:100%;width:100%;margin-top:0px !important;margin-bottom:10px !important;}[data-css="tve-u-16f81145c40"]::after{clear:both;}:not(#tve) [data-css="tve-u-16f81145c3f"] .tcb-button-link{line-height:1.2em;font-size:18px;}[data-css="tve-u-16f81145c3f"] .tcb-button-link{padding-right:15px;padding-left:15px;border-radius:3px;overflow:hidden;border-color:#b5b5b5;padding-top:12px !important;padding-bottom:12px !important;background-color:#0077b5 !important;background-image:none !important;}[data-css="tve-u-16f81145c3f"] .tcb-button-link.nitro-lazy{background-image:none !important;}[data-css="tve-u-16f81145c42"] p{padding:0px 0px 7px !important;margin:0px !important;}:not(#tve) [data-css="tve-u-16f81145c43"]{--g-regular-weight:400;--g-bold-weight:700;padding-bottom:0px !important;margin-bottom:0px !important;font-family:Montserrat !important;font-weight:var(--g-regular-weight,normal) !important;}:not(#tve) [data-css="tve-u-16f81145c43"] strong{font-weight:700 !important;}[data-css="tve-u-16f81145c45"]{border-top:none !important;background-color:#e1eef3 !important;}[data-css="tve-u-16f81145c47"]{max-width:52.6%;}[data-css="tve-u-16f81145c48"]{max-width:47.4%;}[data-css="tve-u-16f81145c4a"]{float:left;z-index:3;position:relative;display:block;max-width:100%;width:100%;margin-top:0px !important;margin-bottom:10px !important;}:not(#tve) [data-css="tve-u-16f81145c4a"] .tcb-button-link{line-height:1.2em;font-size:18px;}[data-css="tve-u-16f81145c4a"] .tcb-button-link{padding-right:15px;padding-left:15px;border-radius:3px;overflow:hidden;padding-top:12px !important;padding-bottom:12px !important;background-color:#f00 !important;}[data-css="tve-u-16f81145c4b"] > .tcb-flex-col{padding-left:5px;}[data-css="tve-u-16f81145c4b"]{margin-left:-5px;flex-flow:row wrap !important;padding-bottom:0px !important;padding-top:10px !important;}[data-css="tve-u-16f81145c4b"] > .tcb-flex-col > .tcb-col{justify-content:center;}[data-css="tve-u-16f81145c4d"]{float:none;margin:0px auto !important;}[data-css="tve-u-16f81145c4e"]{margin-bottom:0px !important;padding-top:40px !important;margin-top:0px !important;padding-bottom:40px !important;}[data-css="tve-u-16f81145c50"]{height:30px;top:0px;transform:rotate(180deg);}[data-css="tve-u-16f81145c51"]{height:30px;bottom:0px;fill:#fff;}[data-css="tve-u-16f81145c4b"] .tcb-flex-col{flex-basis:250px !important;}:not(#tve) [data-css="tve-u-1709b5dd4dd"]{font-weight:var(--g-bold-weight,bold) !important;}}@import url("//fonts.googleapis.com/css?family=Montserrat:400,900,700,800,500&subset=latin");@media (min-width:300px){:not(#tve) [data-css="tve-u-1657ac30110"]{font-family:Georgia,serif,Verdana,Geneva,sans-serif !important;color:#f00 !important;}[data-css="tve-u-16e83478d1f"] .tve_sep{background-image:url("data:image/svg+xml;charset=utf8,%3Csvg version=\'1.1\' xmlns=\'http://www.w3.org/2000/svg\' xmlns:xlink=\'http://www.w3.org/1999/xlink\' x=\'0px\' y=\'0px\' viewBox=\'0 0 9 3\' style=\'enable-background:new 0 0 9 3;\' xml:space=\'preserve\'%3E%3Crect x=\'2\' y=\'1\' fill=\'rgb(66,66,66)\' width=\'5\' height=\'1\'/%3E%3C/svg%3E");background-size:1px 1px;height:1px !important;}[data-css="tve-u-16e83478d1f"] .tve_sep.nitro-lazy{background-image:none !important;}:not(#tve) [data-css="tve-u-16f86133859"]{font-size:13px !important;}[data-css="tve-u-16f8613385b"]{width:86px;margin-bottom:5px !important;margin-top:5px !important;}[data-css="tve-u-16f8613385d"]{margin-top:0px;margin-left:0px;}[data-css="tve-u-16f8613385e"]{float:left;z-index:3;position:relative;display:block;max-width:100%;width:100%;margin-top:0px !important;margin-bottom:10px !important;}[data-css="tve-u-16f86133860"]::after{clear:both;}:not(#tve) [data-css="tve-u-16f8613385e"] .tcb-button-link{line-height:1.2em;font-size:18px;}[data-css="tve-u-16f8613385e"] .tcb-button-link{padding-right:15px;padding-left:15px;border-radius:3px;overflow:hidden;border-color:#b5b5b5;padding-top:12px !important;padding-bottom:12px !important;background-color:#0077b5 !important;background-image:none !important;}[data-css="tve-u-16f8613385e"] .tcb-button-link.nitro-lazy{background-image:none !important;}[data-css="tve-u-16f86133861"] p{padding:0px 0px 7px !important;margin:0px !important;}:not(#tve) [data-css="tve-u-16f86133863"]{--g-regular-weight:400;--g-bold-weight:700;padding-bottom:0px !important;margin-bottom:0px !important;font-family:Montserrat !important;font-weight:var(--g-regular-weight,normal) !important;}:not(#tve) [data-css="tve-u-16f86133863"] strong{font-weight:700 !important;}[data-css="tve-u-16f86133865"]{border-top:none !important;background-color:#e1eef3 !important;}[data-css="tve-u-16f86133866"]{max-width:52.6%;}[data-css="tve-u-16f86133868"]{max-width:47.4%;}[data-css="tve-u-16f86133869"]{float:left;z-index:3;position:relative;display:block;max-width:100%;width:100%;margin-top:0px !important;margin-bottom:10px !important;}:not(#tve) [data-css="tve-u-16f86133869"] .tcb-button-link{line-height:1.2em;font-size:18px;}[data-css="tve-u-16f86133869"] .tcb-button-link{padding-right:15px;padding-left:15px;border-radius:3px;overflow:hidden;padding-top:12px !important;padding-bottom:12px !important;background-color:#f00 !important;}[data-css="tve-u-16f8613386b"] > .tcb-flex-col{padding-left:5px;}[data-css="tve-u-16f8613386b"]{margin-left:-5px;flex-flow:row wrap !important;padding-bottom:0px !important;padding-top:10px !important;}[data-css="tve-u-16f8613386b"] > .tcb-flex-col > .tcb-col{justify-content:center;}[data-css="tve-u-16f8613386d"]{float:none;margin:0px auto !important;}[data-css="tve-u-16f8613386e"]{margin-bottom:0px !important;padding-top:40px !important;margin-top:0px !important;padding-bottom:40px !important;}[data-css="tve-u-16f8613386f"]{height:30px;top:0px;transform:rotate(180deg);}[data-css="tve-u-16f86133871"]{height:30px;bottom:0px;fill:#fff;}[data-css="tve-u-16f8613386b"] .tcb-flex-col{flex-basis:250px !important;}}.tve_faq{background:#fff;}.tve_faq{background:#fff !important;}.one-container .inside-article{padding:0 0 5px 0;}.entry-summary{margin:1em 0 0;}.tve_faq{background:#fff;}.tve_faq{background:#fff !important;}#tve_editor .thrv_toggle_shortcode .tve_faq:hover>.tve_faqI>.tve_faqB h4:not(.tve_toggle_open_text){color:#000 !important;}.awr-i a{text-decoration:underline;}.awr-i a:hover{text-decoration:none;}.awr-i{line-height:2em;}.side-list{font-family:Verdana,sans-serif;padding:10px 10px 10px 10px;}.side-list p{border-bottom:1px dotted #e2e2e2;margin:0;padding:5px 0;}.side-list p a:link{text-decoration:none;color:#fff;margin-bottom:0;}.side-list p a:visited{text-decoration:none;color:#000;margin-bottom:0;}.side-list p a:hover{padding-left:10px;margin-bottom:0;}.side-list-header{font-size:16px;font-weight:700;border:0;}.ks{background-color:#f2f2f2;padding:10px;border:1px solid #d7dfc0;border-radius:5px;font-family:Verdana,Geneva,sans-serif;font-size:16px;margin:5px;}.ksp{margin:0;}.entry-title{margin-bottom:25px;}.outer a:link{text-decoration:none;}.outer a:hover{text-decoration:none;}pre{font-family:monospace;background:#f4f4f4;border-color:#3a3a3a;border-style:dashed;border-width:0 0 0 1px;font-weight:300;font-size:15px;line-height:30px;margin:20px 0 20px 0;overflow:auto;padding:10px;white-space:pre-wrap;word-wrap:break-word;}.fn a:link{text-decoration:none;}.fn a:hover{text-decoration:none;}.link a:link{color:#00e;border-bottom:1px dotted #7a7a7a;}.link a:hover{color:#00e;}.sAsCont section .scn{border-bottom-left-radius:0;border-bottom-right-radius:0;background:#fff;border:0 solid #e9e9e9;position:relative;padding:5px 0;}.sugtips{font-size:13px;}.sugtips ul{list-style-type:square;list-style-position:outside;font-size:15px;}h5{font-family:"PT Serif";}ul img{margin-bottom:20px;margin-top:20px;display:block;margin-left:auto;margin-right:auto;}ol img{display:block;margin-left:auto;margin-right:auto;margin-bottom:20px;margin-top:20px;}.full-article-footer{border-top:1px solid #e0dfdb;}.article-footer{padding:20px 10px 10px 10px;min-height:115px;display:table;}.avatar-module{display:table-cell;vertical-align:middle;}.avatar-module img{border-radius:50% !important;height:120px;width:120px;float:left;margin:0 20px 0 20px;}.article-footer p{line-height:1.5em;padding-left:15px;}a.author-link{font-size:25px;line-height:2em;color:#617a3a;text-decoration:none;}a.author-link:hover{color:#000;text-decoration:none;}@media (max-width:750px){.article-footer{display:inherit;margin:0;}.avatar-module{display:inherit;vertical-align:none;}.avatar-module img{margin-left:auto;margin-right:auto;display:block;float:none;margin-top:0;}.article-footer p{text-align:center;padding-left:0;}}.author-block{padding:20px 30px;background-color:#f6f6f6;border:1px solid #ddd;}.author-title{font-family:Verdana,Geneva,sans-serif;font-size:20px;font-weight:700;}.author-info{max-width:100%;overflow:hidden;}.author-info img{max-width:20%;overflow:hidden;float:left;}.author-info .author-intro{padding:0 0 0 30px;max-width:70%;overflow:hidden;float:left;}.author-info p.author-name{font-family:Verdana,Geneva,sans-serif;font-size:24px;font-weight:400;}.author-info{font-family:Verdana,Geneva,sans-serif;font-size:16px;font-weight:400;line-height:22px;}.author-info p.author-brief{font-family:Verdana,Geneva,sans-serif;font-size:16px;font-weight:400;line-height:22px;}.author-info a{text-decoration:none;font-family:Verdana,Geneva,sans-serif;font-size:16px;font-weight:400;line-height:22px;}@media (max-width:768px){.author-block{width:100%;overflow:hidden;text-align:center;padding:0;}.author-info .author-img{width:45%;margin:auto;overflow:hidden;display:block;}.author-info .author-img img{max-width:100%;overflow:hidden;margin-left:auto;margin-right:auto;display:block;}.author-info .author-intro{padding:0;max-width:100%;overflow:hidden;}.author-info p.author-brief{font-family:Verdana,Geneva,sans-serif;font-size:16px;font-weight:400;line-height:10px;}}#breadcrumbs{background-color:#fff;padding-left:10px;font-size:12px;}ul.breadcrumb{padding:5px 5px;list-style:none;background-color:#fff;}ul.breadcrumb li{display:inline;font-size:13px;}ul.breadcrumb li+li:before{padding:8px;color:#000;content:"/0a0";}ul.breadcrumb li a{color:#0275d8;text-decoration:none;}ul.breadcrumb li a:hover{color:#01447e;text-decoration:underline;}h3,h4,h5,h6{margin-bottom:0;}.content-box-army,.content-box-blue,.content-box-gray,.content-box-green,.content-box-grey,.content-box-purple,.content-box-red,.content-box-yellow{margin:0 0 35px;overflow:hidden;padding:20px;}.content-box-blue{background-color:#f0f8ff;border-left:8px solid #cee1ef;}.content-box-grey{background-color:#f6f6f6;border-left:12px solid #ff8d1d;}.content-box-green{background-color:#f5faff;border-left:8px solid #13a37d;}.content-box-red{background-color:#f9dbdb;border-left:8px solid #ff2929;}pre[class*=language-]{font-size:16px;margin-bottom:2em;},code[class*=language-]{font-size:16px;margin-bottom:0;}.entry-content p a:link{color:#00e;border-bottom:1px dotted #7a7a7a;}.entry-content p a:hover{color:#00e;}.entry-content ol a:link{color:#00e;border-bottom:1px dotted #7a7a7a;}.entry-content ol a:hover{color:#00e;}.entry-content ul a:link{color:#00e;border-bottom:1px dotted #7a7a7a;}.entry-content ul a:hover{color:#00e;},.content-box-grey{background-color:#f6f6f6;border-left:12px solid #ff8d1d;}.content-box-orange{background-color:#f5faff;border-left:8px solid #13a37d;}.wp-block-ub-content-toggle h2{font-size:26px;}.tip-box{background-color:#c6edfa;border-left:8px solid #13a37d;padding:10px 20px 10px 20px;}.main-note{font-family:Georgia,Times,Times New Roman,serif;font-size:21px;overflow:hidden;padding:20px;background-color:#f5faff;border-left:2px solid #13a37d;}.formula{font-size:18px;color:#31708f;padding-left:5px;font-weight:700;padding:20px;background-color:#d9edf7;border:1px solid #bcdff1;border-radius:4px;}