Fixing Data Dump with Power Query: IF- OR- AND- Excel Problem #2 SOLVED

I frequently receive questions on my Social Media platforms. I decided in this new series "Problem Solved", to share the problems that might be interesting to other users and solve these problems while explaining the topic, for the benefit to spread.
Today's Excel problem is from a client in one of my Corporate Training Sessions about Fixing a Data Dump. Listen to the problem in his own words, then watch me break it down and solving it.
You can send me your Excel problems and sample files (with no sensitive data) and if I find it useful to others as well, I might record a video on that and add it to the series "Problem Solved".
To send an Excel problem you can add it as a comment to :
Youtube.com/OfficeInstructor
Facebook.com/OfficeInstructor
www.OfficeInstructor.com

I sincerely hope you can keep supporting my channel by sharing my videos, giving a thumbs up and subscribing to my channel.
##################################################### ****************************************************************************
You can Master Excel by learning clever techniques that combine Data validation with almost every tool in Excel. My new Book :
**************** Data Validation a back door to Master Excel ********************** **************************** is Now Available at ***************************** ************************* www.Amazon.com ******************************** ************************* www.Amazon.com ******************************** My New Book Is Now available on Amazon. It is much more than the Data Validation you know! Through Data Validation I Cover over 60 different Functions, Charts, Slicers, Pivot Tables, Conditional Formatting, Macros, Power Query, Dynamic Arrays, DAX, Data Model and VBA.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Booking a Corporate Training (at Client Site or Remotely)
************************ Book A Corporate Training ************************* ****************************** With Nabil Mourad ************************* ************************* www.OfficeInstructor.com *********************** ************************* www.OfficeInstructor.com ************************ ##################################################### ****************************************************************************

Видео Fixing Data Dump with Power Query: IF- OR- AND- Excel Problem #2 SOLVED канала Officeinstructor