Power Query - Unstack Rows with List.Alternate

There are many ways to Unstack rows into columns in this tutorial i show you how to use list.Alternate and then a little bonus how to do it in one line using list.Split.
#dataanalytics #excel #powerbi #powerquery #powerbidesktop #tutorial #mquery #microsoft
File Link
github.com/jbotes/powerbiTuto...
MQuery Links
List.Alternate
learn.microsoft.com/en-us/pow...
List.Skip
learn.microsoft.com/en-us/pow...
List.split
learn.microsoft.com/en-us/pow...
table.FromColumns
learn.microsoft.com/en-us/pow...

Пікірлер: 19

  • @MichaelBrown-lw9kz
    @MichaelBrown-lw9kz4 ай бұрын

    Impressive stuff. I have to accept that it will take me years of practice to master Power Query and DAX.

  • @mnowako
    @mnowako3 ай бұрын

    Amazing! Thanks a lot!

  • @yousrymaarouf2931
    @yousrymaarouf29313 ай бұрын

    Fantastic

  • @rajanpradeepankarath8846
    @rajanpradeepankarath884617 күн бұрын

    brilliant!

  • @corradoagnoletto905
    @corradoagnoletto9053 ай бұрын

    Interesting! But to get an array from a list the fast way is to use the index function with sequence.

  • @tonybatty504
    @tonybatty5044 ай бұрын

    Great series of videos and learnt a lot of PQ functions!

  • @fortunatodirado3176
    @fortunatodirado31763 ай бұрын

    Thanks!!!

  • @aart_analyst
    @aart_analyst4 ай бұрын

    Good stuff, James. Always learning new things with you.

  • @aman_mashetty5185
    @aman_mashetty51854 ай бұрын

    Awesome..! Never knew about list.alternate

  • @IvanCortinas_ES
    @IvanCortinas_ES3 ай бұрын

    Complex function. Thank you.

  • @kebincui
    @kebincui4 ай бұрын

    Awesome as always 👍

  • @ExcelWithChris
    @ExcelWithChris4 ай бұрын

    Dankie!!!

  • @basensei8699

    @basensei8699

    3 ай бұрын

    plesier Chris!

  • @gabriusv
    @gabriusv3 ай бұрын

    Hey James, it sounds like your microphone audio is mixed only through the left channel. Your audio effects are correctly playing through both the left & right channels. As a quick band-aid, you could try turning your microphone audio from dual channel to mono! I do see that you're using a dedicated microphone, so it's possible your not recording from the correct source. Hard to diagnose without knowing your set-up. Let's chat some time! I also come from a video editing background & I know enough about audio to be dangerous.

  • @VintageReplay-pt5xk
    @VintageReplay-pt5xk3 ай бұрын

    Just hijacking your video here, I have tried reaching out to you on your contact form the on website but this isnt working for some reason! You have a goldmine of info on this chanel and I was trying to get in contact to see if you could do some ad-hoc consultancy for me as I am having a mare of a job trying to get a couple of queries going!

  • @basensei8699

    @basensei8699

    3 ай бұрын

    Glorious ! Thank you indeed! And Sure thing contact me on jamesbotes@basensei.com :)

  • @lcorcoran56
    @lcorcoran564 ай бұрын

    Love the video's, I learn a lot, but I keep thinking there is something wrong with earbubs, I only hear him out of the left ear bud if he plays Any other sounds it is fine, so it get annoying with the bad audio sorry if I sound like at troll

  • @MrJamesbotes

    @MrJamesbotes

    4 ай бұрын

    Damn I didn't know that ! I think it might be my mic ! Thank you for letting me know !

  • @basensei8699

    @basensei8699

    4 ай бұрын

    thanks for letting me know man i really didnt even know about this until now!