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

@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:"Open Sans",sans-serif;font-size:18px;}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:Verdana,Geneva,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:900;margin-bottom:10px;}h2{font-family:"Montserrat",sans-serif;font-weight:700;font-size:34px;margin-bottom:15px;}h3{font-family:"Montserrat",sans-serif;font-weight:700;font-size:26px;line-height:1.5em;}h4{font-family:"PT Serif",serif;font-weight:900;font-size:20px;line-height:1.6em;}h5{font-size:inherit;line-height:1em;}.site-info{font-family:Verdana,Geneva,sans-serif;}@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;}.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:#0a0000;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:#0a0000;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:#737373;}h3{color:#b2b2b2;}h4{color:#b2b2b2;}.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.3/webfonts/075602bebe5ca554ceb0bd17424140f1.fa-brands-400.eot"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/075602bebe5ca554ceb0bd17424140f1.fa-brands-400.eot#iefix") format("embedded-opentype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/902e7332269205002a5894d287cecdb5.fa-brands-400.woff2") format("woff2"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/d6791185cd44a83eda7f482c355a7bc9.fa-brands-400.woff") format("woff"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/2c54ec874a5970e4a81ca75bdf0dfd24.fa-brands-400.ttf") format("truetype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/releases/v5.15.3/webfonts/7eec1192b7db0c309b7f37d8e3a3744e.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.3/webfonts/8875be731f8293b6b4b27d11f56a0663.fa-solid-900.eot"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/8875be731f8293b6b4b27d11f56a0663.fa-solid-900.eot#iefix") format("embedded-opentype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/590c7e3fc61bb6427641ce74f46ce489.fa-solid-900.woff2") format("woff2"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/06fda4f286910c247be5b4d44223a434.fa-solid-900.woff") format("woff"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/a19ffdf10e54da83960b20a1bd598efa.fa-solid-900.ttf") format("truetype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/releases/v5.15.3/webfonts/8a1e250271e3cf2057e7caea414b46b5.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.3/webfonts/6f6d071bfa07c905f52450eac285c5b7.fa-regular-400.eot"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/6f6d071bfa07c905f52450eac285c5b7.fa-regular-400.eot#iefix") format("embedded-opentype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/4425edfaa50a49eb48c6961835683eeb.fa-regular-400.woff2") format("woff2"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/9865d70b4ebd1a1f8fb445203ae13c89.fa-regular-400.woff") format("woff"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/source/releases/v5.15.3/webfonts/14fd4e08f36a5a14e51a59dccd95dd7a.fa-regular-400.ttf") format("truetype"),url("https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/releases/v5.15.3/webfonts/eb3b87fd12a82193c95c7a59ba5f0282.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;}: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;}.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:0em;}.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;}