Results 1 to 6 of 6

Thread: Power Query: Combine Files, delete row1, promote row2 as headers
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2015
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query: Combine Files, delete row1, promote row2 as headers

    I'm trying to combine files in PQ that have an extra row above the headers.

    How would I combine these files by deleting Row1 and promoting Row2 as headers?


    Count 5
    ID Action Date
    11111 INP 18-Oct
    22222 INP 19-Oct
    33333 INP 20-Oct
    44444 CLOSED 21-Oct
    55555 INP 22-Oct

    Count 3
    ID Action Date
    66666 CLOSED 18-Oct
    77777 INP 19-Oct
    88888 INP 20-Oct

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,009
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query: Combine Files, delete row1, promote row2 as headers

    remove top rows: 1
    promote
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  3. #3
    Board Regular
    Join Date
    Mar 2015
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query: Combine Files, delete row1, promote row2 as headers

    Quote Originally Posted by sandy666 View Post
    remove top rows: 1
    promote
    thanks all who viewed this. Discovered the awesome create M functions from parameterized queries.

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,009
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Power Query: Combine Files, delete row1, promote row2 as headers

    sure but we don't know your wonderful M functions and queries with parameter
    Last edited by sandy666; Oct 18th, 2019 at 05:20 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  5. #5
    Board Regular
    Join Date
    Mar 2015
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query: Combine Files, delete row1, promote row2 as headers

    1. Save all the files in the same folder

    2 On the Excel 2016 menu bar choose Data-->New Query --> From File --> From Folder

    3. After choosing the folder; choose the Combine & Edit . Choose OK in the next screen.

    4. Go to Workbook Queries editor and select the Transform Sample File. This is the base table for the formula you create prior to work. Make all changes here. Remove first row, promote headers...etc.

  6. #6
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,009
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query: Combine Files, delete row1, promote row2 as headers

    I don't see any M function and any parameter, but if it works for you that's great

    have a nice day
    Last edited by sandy666; Oct 18th, 2019 at 05:53 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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