Excel Power Query Tutorial - Merging Tables (VLOOKUP Alternative)

[@aytacavcilar1330]

Super simple, clean and quick tutorial on KZbin. 👍

[@DaveOnData]

Thank you for the feedback, glad you liked the video!

[@sathyesh-si5vy]

Waiting for next video 🤗... Really appreciate

[@AOPsimi]

Hi David, I just subscribed to your channel and I’m super excited!

[@DaveOnData]

Awesome! I hope you find the content useful.

[@Data_Mom]

Simple and quick video, enjoyed watching.

[@DaveOnData]

As always, appreciate the feedback and glad you enjoyed the video!

[@laxmanrao4554]

The best part about yout videos (that I feel) is the design thinking process, to build hypothesis and then what we want to see followed by what we need to reach there and finally reaching there . Thank you 💗

[@joeltochukwu4199]

Thank you. When are we expecting the next video?

[@eunicen4250]

Awesome stuff. very insightful. very clear step by step tutorial. thankyou so much David

[@DaveOnData]

My pleasure!

[@Sandy-qt5su]

super helpful, waiting for the next one Dave ;)

[@DaveOnData]

Excellent! Glad you found the content.

[@flaviobertasi2728]

Great job! Thank you so much for your super useful vids..

[@DaveOnData]

Thank you for the feedback, much appreciated! So glad you are finding my content useful.

[@VaibhavRungta]

Hello @david langer, these are incredibly helpful videos :-) I am working with a larger data set and after getting the power query table (green one) I am trying to apply some formulas on it. Most of the formulas are either breaking or not allowing me to exclude headers from selections (eg: UNIQUE and FILTER). Is this common? I am not using pivot because the breaks I am trying to see (often on 2 axis) are easier to create using formulas than pivots and size of the sheet becomes too large with more pivot tables. Any suggestions? Thanks

[@DaveOnData]

If I understand your situation correctly, I think Power Query might be useful here. Power Query can create pivots (i.e., grouping tables). This video might be helpful: kzbin.info/www/bejne/mHS9cpmDd5iGors

[@mog1888]

Great videos David...would you be able to show how to store weekly comments when the file changes with new orders

[@shhruti6775]

You are awesome

[@davidably]

👍

[@statistikochspss-hjalpen8335]

It's was a bit too complex pivot table. It would've been good if you showed percentage instead of count.

[@JaveGeddes]

Your voice goes from normal to a whisper..

[@piotrr597]

Channel dead? :( soo sad