+ Reply to Thread
Results 1 to 4 of 4

Power query header row delete

  1. #1
    Registered User
    Join Date
    02-10-2019
    Location
    UK
    MS-Off Ver
    Windows 10, Office 365 Business
    Posts
    9

    Question Power query header row delete

    Hello and thank you for reading this message. I have searched through existing messages for an answer but cannot find an existing answer.

    In power query, I can fully copy a table from a website into Excel. However there is a header row which I would like to delete. I cannot find a way to delete the header row. Is there a way please?

    Thank you again for reading.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Power query header row delete

    Do you mean column headers or the first row? Either way, you can either promote the first row as headers in Power Query before you close and load, or use the remove rows option.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    02-10-2019
    Location
    UK
    MS-Off Ver
    Windows 10, Office 365 Business
    Posts
    9

    Re: Power query header row delete

    Hello and thank you for your reply.
    With your tip that there is a way, I have searched into the options and found the way now.
    Thank you for your reply.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Power query header row delete

    Great!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query VBA to Omit/Delete & Seperate Data From .CSV
    By Ourkid123uk in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-05-2019, 10:47 AM
  2. [SOLVED] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  3. POWER Query and Power Pivot Table !!
    By haitham.shop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-06-2018, 04:09 PM
  4. Power Query and Power Pivot Table
    By haitham.shop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-06-2018, 06:17 AM
  5. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  6. Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  7. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1