locked
Power Query: Stacking 2 columns RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Fellow power query users,

    I have a need to stack emails from two different columns so email 2 goes below email 1.  How do I do that in power query?  I use transform, merge then it concatenated back.  It was together with , (comma) before then I separated it and want them to be in one column. Googling around and couldn't find the way to do it.  Help!!!

    

    NLuu

    Thursday, April 18, 2019 3:27 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    The solution provided in the link below might help:

    https://social.technet.microsoft.com/Forums/en-US/69923ffd-319c-440d-b32c-92300dc67b9d/combining-colums-in-one-powerquery?forum=powerquery

    • Marked as answer by NLuu Thursday, April 18, 2019 8:01 PM
    Thursday, April 18, 2019 7:56 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    The solution provided in the link below might help:

    https://social.technet.microsoft.com/Forums/en-US/69923ffd-319c-440d-b32c-92300dc67b9d/combining-colums-in-one-powerquery?forum=powerquery

    • Marked as answer by NLuu Thursday, April 18, 2019 8:01 PM
    Thursday, April 18, 2019 7:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Colin

    NLuu

    Thursday, April 18, 2019 8:02 PM