www.myonlinetraininghub.com Open in urlscan Pro
107.154.149.68  Public Scan

Form analysis
3 forms found in the DOM

Name: sfsearch — POST https://www.myonlinetraininghub.com/wp-admin/admin-ajax.php?action=search&_wpnonce=918a21ccc8

<form id="spSearchForm" class="spSubmitSearchForm" action="https://www.myonlinetraininghub.com/wp-admin/admin-ajax.php?action=search&amp;_wpnonce=918a21ccc8" method="post" name="sfsearch" data-id="" data-type="form" data-min="3">
  <div class="spLeft spSearchForm"><input type="text" id="searchvalue" class="spControl" size="20" name="searchvalue" value="" placeholder="Search..."><a rel="nofollow" id="spSearchButton" class="spButton spSearchSubmit" title="Search the forums" data-id="spSearchButton" data-type="link" data-min="3"><img class="spIcon" src="https://www.myonlinetraininghub.com/wp-content/sp-resources/forum-themes/reboot/images/lightpack/sp_Search.png" alt="sp_Search">
Search</a>
    <div style="clear: both; height:1px;"></div>
    <a class="spSearchLink spAdvancedSearchForm" data-id="spSearchFormAdvanced">Advanced Search</a>
  </div>
  <div style="clear: both; height:1px;"></div>
  <div id="spSearchFormAdvanced" class="spSearchFormAdvanced">
    <fieldset class="spSearchFormAdvanced">
      <legend>Search</legend>
      <div class="spSearchSection spSearchSectionForm ">
        <div class=" spRadioSection spLeft"><span class="spSearchForumScope">Forum Scope</span><br><input type="hidden" name="forumslug" value="power-query"><input type="hidden" name="forumid" value="9"><input type="radio" id="sfradio1"
            name="searchoption" value="1" checked="checked"><label class="spLabel spRadio" for="sfradio1">Current forum</label><br><input type="radio" id="sfradio2" name="searchoption" value="2"><label class="spLabel spRadio" for="sfradio2">All
            forums</label><br>
          <hr><input type="checkbox" id="spCheckBlog" name="blogsearchoption" value="0"><label class="spLabel spCheckBox" for="spCheckBlog">Include blog posts</label><br>
        </div>
        <div class=" spRadioSection spLeft"><span class="spSearchMatch">Match</span><br><input type="radio" id="sfradio3" name="searchtype" value="1" checked="checked"><label class="spLabel spRadio" for="sfradio3">Match any word</label><br><input
            type="radio" id="sfradio4" name="searchtype" value="2"><label class="spLabel spRadio" for="sfradio4">Match all words</label><br><input type="radio" id="sfradio5" name="searchtype" value="3"><label class="spLabel spRadio"
            for="sfradio5">Match phrase</label><br></div>
        <div class=" spRadioSection spLeft"><span class="spSearchOptions">Forum Options</span><br><input type="radio" id="sfradio6" name="encompass" value="1" checked="checked"><label class="spLabel spRadio" for="sfradio6">Posts
            only</label><br><input type="radio" id="sfradio7" name="encompass" value="2"><label class="spLabel spRadio" for="sfradio7">Topic titles only</label><br><input type="radio" id="sfradio8" name="encompass" value="3"><label
            class="spLabel spRadio" for="sfradio8">Posts and topic titles</label><br></div>
        <div class="spLeft spSearchDetails ">Minimum search word length is <b>3</b> characters - maximum search word length is <b>84</b> characters</div>
      </div>
      <div class="spSearchFormSubmit"><a rel="nofollow" id="spSearchButton2" class="spButton spSearchSubmit" title="Search the forums" data-id="spSearchButton2" data-type="link" data-min="3"><img class="spIcon" src="https://www.myonlinetraininghub.com/wp-content/sp-resources/forum-themes/reboot/images/lightpack/sp_Search.png" alt="sp_Search">
Search</a></div>
    </fieldset>
  </div>
</form>

Name: loginform — POST https://www.myonlinetraininghub.com/wp-login.php

<form name="loginform" id="loginform" class="spForm" action="https://www.myonlinetraininghub.com/wp-login.php" method="post">
  <label class="" for="log">Login name<br><input type="text" class="spControl" tabindex="84" name="log" id="log" value="" size="11"></label>
  <div style="clear: both; height:12px;"></div>
  <label class="" for="login_password">Password<br><input type="password" class="spControl" tabindex="85" name="pwd" id="login_password" value="" size="11"></label>
  <div style="clear: both; height:12px;"></div>
  <div style="clear: both; height:4px;"></div>
  <input type="checkbox" tabindex="86" id="rememberme" name="rememberme" value="forever"><label class="" for="rememberme">Remember me</label>
  <input type="submit" class="spSubmit" name="submit" id="submit" value="Log In" tabindex="87" style="float:right">
  <input type="hidden" name="redirect_to" value="/excel-forum/power-query/download-filed">
</form>

POST #

<form action="#" method="post" novalidate="novalidate">
  <div class="tve_lead_generated_inputs_container tve_clearfix tve_empty_dropzone">
    <div class="tve_lg_input_container tve_lg_input" data-css="tve-u-115d51532867fdd">
      <input type="email" data-field="email" data-required="1" data-validation="email" name="email" placeholder="Type Your Email Here" data-placeholder="Type Your Email Here" class="">
    </div>
    <div class="tve_lg_input_container tve_submit_container tve_lg_submit" data-css="tve-u-125d5153286801e">
      <button type="submit" class="" style=""><span class=""><strong>Download My eBook</strong></span></button>
    </div>
  </div>
  <input id="_submit_option" type="hidden" name="_submit_option" value="redirect"><input id="_back_url" type="hidden" name="_back_url" value="https://www.myonlinetraininghub.com/exit-thank-you"><input id="_autofill" type="hidden" name="_autofill"
    value=""><input type="hidden" name="__tcb_lg_fc" id="__tcb_lg_fc" value="YToxOntzOjk6Im1haWxjaGltcCI7czoxMDoiYjUyNTI1MzllMSI7fQ=="><input type="hidden" id="mailchimp_groupin" class="tve-api-extra" name="mailchimp_groupin"
    value="14a654c2e0"><input type="hidden" id="mailchimp_group" class="tve-api-extra" name="mailchimp_group" value="c7cf2c5a3e"><input type="hidden" id="mailchimp_optin" class="tve-api-extra" name="mailchimp_optin" value="s"><input type="hidden"
    id="mailchimp_tags" class="tve-api-extra" name="mailchimp_tags" value="">
</form>

Text Content

 * Skip to primary navigation
 * Skip to main content
 * Skip to footer

 * My Courses
   
 * Login
   

☰ Menu

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

 * Courses
 * Pricing
   * Free Courses
   *  SALE   Power BI Course
   * Excel Power Query Course
   * Power Pivot and DAX Course
   *  SALE   Excel Dashboard Course
   * Excel PivotTable Course – Quick Start
   * Advanced Excel Formulas Course
   * Excel Expert Advanced Excel Training
   * Excel Tables Course
   * Excel, Word, Outlook
   * Financial Modelling Course
   * Excel PivotTable Course
   * Excel for Customer Service Professionals
   * Multi-User Pricing
 * Resources
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * IF Function
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Members
   * Login
 * Blog
 * Excel Webinars
 * Excel Add-ins
 * Excel Forum
   * Register as Forum Member
 * Cart
   


POWER QUERY | EXCEL FORUM

This forum requires Javascript to be enabled for posting content

Log In Register

Select Forum Forum Rules and Guides General Excel Questions & Answers Dashboards
& Charts VBA & Macros Power Query Power Pivot Excel Dashboards Power Query Power
Pivot Xtreme Pivot Tables Excel for Decision Making Excel for Finance Power BI
Excel Word Outlook Excel Expert Excel for Customer Service Professionals Excel
Analysis Toolpak Excel Tables Excel for Operations Management Financial
Modelling Advanced Excel Formulas Pivot Tables Quick Start
Select Forum
 * Select Forum
   
 * Rules and Guides
   * Forum Rules and Guides
     
 * Public Forums - For Registered Users
   * General Excel Questions & Answers
     
   * Dashboards & Charts
     
   * VBA & Macros
     
   * Power Query
     
   * Power Pivot
     
 * Course Members Only
   * Excel Dashboards
     
   * Power Query
     
   * Power Pivot
     
   * Xtreme Pivot Tables
     
   * Excel for Decision Making
     
   * Excel for Finance
     
   * Power BI
     
   * Excel
     
   * Word
     
   * Outlook
     
   * Excel Expert
     
   * Excel for Customer Service Professionals
     
   * Excel Analysis Toolpak
     
   * Excel Tables
     
   * Excel for Operations Management
     
   * Financial Modelling
     
   * Advanced Excel Formulas
     
   * Pivot Tables Quick Start
     

New / Updated Topics Excel Data Set Resize Solution Calculations based on (and
if) data exis… Counting within blocks of data Calculate 1000 tasks date Bar
Cjhart colors reset upon refresh Plot rankings over time, series labels e…
Dynamic Drop-down List for Data From a S… vba code required to manipulate data -
n… Filter column & Add new column and n… How to Create a File in Csv Format
Takin… print questions on making a function for count… Threaded Comment
Extractions in Excel Running totals for the bottom 12 rows gr… Power Query -
Data transformation help! Merge or lookup two nested tables One to Many
VLookup/Power Query Row data getting mixed up after expandin… COMBINING MULTIPLE
EXCEL FILES USING POW… Rounding a Ratio?
New / Updated Topics
 * New / Updated Topics
   
 * General Excel Questions & Answers
   * Excel Data Set Resize Solution
     
   * Calculations based on (and if) data exis…
     
   * Counting within blocks of data
     
   * Calculate 1000 tasks date
     
 * Dashboards & Charts
   * Bar Cjhart colors reset upon refresh
     
   * Plot rankings over time, series labels e…
     
   * Dynamic Drop-down List for Data From a S…
     
 * VBA & Macros
   * vba code required to manipulate data - n…
     
   * Filter column & Add new column and n…
     
   * How to Create a File in Csv Format Takin…
     
   * print
     
   * questions on making a function for count…
     
   * Threaded Comment Extractions in Excel
     
 * Power Query
   * Running totals for the bottom 12 rows gr…
     
   * Power Query - Data transformation help!
     
   * Merge or lookup two nested tables
     
   * One to Many VLookup/Power Query
     
   * Row data getting mixed up after expandin…
     
 * Power Query
   * COMBINING MULTIPLE EXCEL FILES USING POW…
     
 * Excel Expert
   * Rounding a Ratio?
     

Search

Advanced Search

Search
Forum Scope
Current forum
All forums


--------------------------------------------------------------------------------

Include blog posts

Match
Match any word
Match all words
Match phrase

Forum Options
Posts only
Topic titles only
Posts and topic titles

Minimum search word length is 3 characters - maximum search word length is 84
characters
Search


Login name


Password



Remember me

Lost password?
HomeExcel ForumPower Query


The requested topic does not exist
Forum Timezone: Australia/Brisbane


Most Users Ever Online: 107
Currently Online: Kalpona Uddin, Riny van Eekelen, Antonia Thomas, Lisa
Castronova
Guest(s) 19
Currently Browsing this Page: Kalpona Uddin, Riny van Eekelen, Antonia Thomas,
Lisa Castronova
5 Guest(s)


Top Posters:
SunnyKow: 1429
Anders Sehlstedt: 818
Velouria: 514
Purfleet: 412
Frans Visser: 346
David_Ng: 306
Aye Mu: 201
lea cohen: 196
A.Maurizio: 189
jaryszek: 183
Newest Members:
Wesley Burchnall
Lisa Castronova
Bryan Robson
Jeannine Martin
Naheean Jalil
Irena Jarni
Rob Hardy
Roger Cheesman
Jari Pennanen
Martin Bannister
Forum Stats:
Groups: 3
Forums: 24
Topics: 5693
Posts: 25025

 

Member Stats:
Guest Posters: 49
Members: 30293
Moderators: 2
Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Riny van Eekelen



© Simple:Press —


OTHER INFO

 * About My Online Training Hub
 * Contact
 * Disclosure Statement
 * Frequently Asked Questions
 * Guarantee
 * Privacy Policy
 * Terms & Conditions
 * Testimonials

 * Excel (113)
 * Excel Charts (83)
 * Excel Dashboard (16)
 * Excel Formulas (176)
 * Excel PivotTables (44)
 * Excel Shortcuts (2)
 * Excel VBA (87)
 * General Tips (6)
 * Online Training (4)
 * Outlook (2)
 * Power Apps (2)
 * Power Automate (1)
 * Power BI (10)
 * Power Pivot (14)
 * Power Query (56)

Help Desk
Excel Resources
Become an Affiliate


Copyright © 2022 · My Online Training Hub ·

Microsoft and the Microsoft Office logo are trademarks or registered trademarks
of Microsoft Corporation in the United States and/or other countries. Product
names, logos, brands, and other trademarks featured or referred to within this
website are the property of their respective trademark holders.





Download A Free Copy of 100 Excel Tips & Tricks

Download My eBook

We respect your privacy. We won’t spam you.

x


Notifications




Shares
Share
Tweet
Pin
Email
Share
Share
Print
Share