{"id":5985,"date":"2017-03-27T15:44:46","date_gmt":"2017-03-27T13:44:46","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5985"},"modified":"2024-02-06T16:09:08","modified_gmt":"2024-02-06T15:09:08","slug":"advanced-editor-in-power-query","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-editor-in-power-query\/","title":{"rendered":"Advanced Editor In Power Query"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-query-excel-2010\/\" target=\"_blank\" rel=\"noopener noreferrer\">Power Query<\/a> in Excel can let us perform a lot of complex steps with our data.<\/p>\n<p>However wouldn&#8217;t it be fun if you could understand better what is happening under the hood? Come join me as we take a look into the <strong>Advanced Editor<\/strong>!<br \/>\nWe will use the\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/create-index-columns-using-power-query\/\" target=\"_blank\" rel=\"noopener noreferrer\">Index Column Post<\/a>\u00a0as our starting point. \u00a0Please download the Excel Workbook below.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-editor-in-power-query\/#Advanced_Editor_In_Power_Query\" title=\"Advanced Editor In Power Query\">Advanced Editor In Power Query<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Editor_In_Power_Query\"><\/span>Advanced Editor In Power Query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/wJTFk4AlxtQ?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p style=\"text-align: center;\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Advanced-Editor.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Let\u2019s go through the steps in detail:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong>:<\/span>\u00a0For us to view the existing <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\" title=\"Power Query\" data-wpil-keyword-link=\"linked\">Power Query<\/a> steps:<\/p>\n<p>Go to <strong><em>Data &gt; Get &amp; Transform &gt; Show Queries (Excel 2016) <\/em><\/strong><em>or<\/em><\/p>\n<p><strong><em>Go to Data &gt; Get &amp; Transform &gt; Show Pane (Excel 2013 &amp; 2010)<\/em><\/strong><\/p>\n<p>Now double click on the\u00a0<em><strong>Table1 <\/strong>query.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Advanced Editor In Power Query\"  class=\"alignnone size-full wp-image-5987\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-01.jpg\" alt=\"Advanced Editor In Power Query\" width=\"533\" height=\"339\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-01.jpg 533w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-01-300x191.jpg 300w\" sizes=\"(max-width: 533px) 100vw, 533px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>This will open up the <strong>Power Query Editor<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Advanced Editor In Power Query\"  class=\"alignnone size-full wp-image-5988\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-02.jpg\" alt=\"Advanced Editor In Power Query\" width=\"370\" height=\"293\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-02.jpg 370w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-02-300x238.jpg 300w\" sizes=\"(max-width: 370px) 100vw, 370px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You can see the Applied Steps\u00a0we have with the<strong> Index Column workbook <\/strong>you downloaded above.<strong> \u00a0<\/strong>The steps are broken down as follows:<\/p>\n<ul>\n<li><strong>SOURCE:<\/strong> Get the Source Table<\/li>\n<li><strong>CHANGED TYPE:<\/strong> Changed the type of columns in the Table<\/li>\n<li><strong>ADDED INDEX:<\/strong> Added an Index Column<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Advanced Editor In Power Query\"  class=\"alignnone size-full wp-image-5989\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-03.jpg\" alt=\"Advanced Editor In Power Query\" width=\"262\" height=\"114\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span>\u00a0<\/strong>Now the fun part! Go to\u00a0<em><strong>Home &gt; Advanced Editor<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Advanced Editor In Power Query\"  class=\"alignnone size-full wp-image-5990\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-04.jpg\" alt=\"Advanced Editor In Power Query\" width=\"361\" height=\"135\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-04.jpg 361w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-04-300x112.jpg 300w\" sizes=\"(max-width: 361px) 100vw, 361px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You will now see our exact 3 steps, in detailed form!<\/p>\n<ul>\n<li>Get the <strong>Table1<\/strong> as the Source<\/li>\n<li>Change the Column Type of <strong>Sales Month<\/strong> to <em>text<\/em>, and <strong>Sales<\/strong> to <em>number<\/em><\/li>\n<li>Add a new index column called <strong>Index<\/strong> that starts at 1 and increments by 1<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Advanced Editor In Power Query\"  class=\"alignnone size-full wp-image-5991\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-05.jpg\" alt=\"Advanced Editor In Power Query\" width=\"791\" height=\"537\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-05.jpg 791w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-05-300x204.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Advanced-Editor-05-768x521.jpg 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You are now able to see what&#8217;s happening under the hood of your Power Query transformations!<\/p>\n<p>Stay tuned as you join me in editing through the Power Query\u00a0<strong>Advanced Editor<\/strong> next time!<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-21.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5921 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-PQ.jpg\" sizes=\"(max-width: 530px) 100vw, 530px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-PQ.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-PQ-300x170.jpg 300w\" width=\"530\" height=\"300\" alt=\"\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Query in Excel can let us perform a lot of complex steps with our data. However wouldn&#8217;t it be fun if you could understand better what is happening under the hood? Come join me as we take a look into the Advanced Editor! We will use the\u00a0Index Column Post\u00a0as our starting point. \u00a0Please download [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17320,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[121,120],"tags":[233,117],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5985"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=5985"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5985\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17320"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=5985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=5985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=5985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}