{"id":11005,"date":"2019-02-08T13:29:39","date_gmt":"2019-02-08T12:29:39","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=11005"},"modified":"2024-02-06T16:09:23","modified_gmt":"2024-02-06T15:09:23","slug":"comment-in-query-steps-in-power-query","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/comment-in-query-steps-in-power-query\/","title":{"rendered":"Comment In Query Steps 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> lets you perform a series of steps to transform your messy Excel data. And if you have a whole lot of steps, you can add your own <strong>comment in query steps<\/strong> in <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>!<\/p>\n<p>This will make it easier for you to understand your query, or if another person will use it, they can pick it up quickly!<\/p>\n<p>Let\u2019s go through the steps in detail:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/D6lfzYA87qE?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><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 class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Comment-in-Query-Steps.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong>:<\/span>\u00a0Let us edit an existing query that we want to modify.<\/p>\n<p>Go to <strong><em>Data &gt; Get &amp; Transform &gt; Show Queries<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/09\/Delete-Steps-Until-End-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Delete Steps Until End In Power Query\"  class=\"alignnone size-full wp-image-9293\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/09\/Delete-Steps-Until-End-01.png\" alt=\"Delete Steps Until End In Power Query\" width=\"694\" height=\"132\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/09\/Delete-Steps-Until-End-01.png 694w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/09\/Delete-Steps-Until-End-01-300x57.png 300w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/a><\/p>\n<p>Double click on your Query to open the\u00a0<strong>Power Query Editor<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/09\/Delete-Steps-Until-End-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Delete Steps Until End In Power Query\"  class=\"alignnone size-full wp-image-9294\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/09\/Delete-Steps-Until-End-02.png\" alt=\"Delete Steps Until End In Power Query\" width=\"451\" height=\"375\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/09\/Delete-Steps-Until-End-02.png 451w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/09\/Delete-Steps-Until-End-02-300x249.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>We want to add a comment to one of our steps. Right click on the step that <strong>removes the top rows<\/strong> and select\u00a0<strong>Properties<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Comment In Query Steps In Power Query\"  class=\"aligncenter size-full wp-image-11008\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps-03.png\" alt=\"Comment In Query Steps In Power Query\" width=\"977\" height=\"730\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps-03.png 977w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps-03-300x224.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps-03-768x574.png 768w\" sizes=\"(max-width: 977px) 100vw, 977px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Since this step removes the first two months, type in the\u00a0<strong>Description &#8220;Remove January and February&#8221;<\/strong> and <strong>click\u00a0<\/strong><strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Comment In Query Steps In Power Query\"  class=\"aligncenter size-full wp-image-11009\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps-04.png\" alt=\"Comment In Query Steps In Power Query\" width=\"411\" height=\"284\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps-04.png 411w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/01\/Comment-in-Query-Steps-04-300x207.png 300w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/p>\n<p>You have saved your first comment in Power Query! You can repeat the same steps for other query steps as well.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>How to\u00a0Comment in Query Steps in Power Query<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/07\/530x300.jpg\" alt=\"Free Excel Macros &amp; VBA Webinar Training\" width=\"530\" height=\"300\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power Query lets you perform a series of steps to transform your messy Excel data. And if you have a whole lot of steps, you can add your own comment in query steps in Power Query! This will make it easier for you to understand your query, or if another person will use it, they [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17946,"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":[573,117],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/11005"}],"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=11005"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/11005\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17946"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=11005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=11005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=11005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}