Power Query: The *Best* Ways to Remove Columns

[@qasimali-gu3oz]

Great video. Let's say I have another scenario of removing empty columns dynamically.
1. Transpoae data
2. Remove empty rows
3.Transpose it back
Another method is the Column.Profile function. This method I have learned from Alejandra Horvath. I am sharing the link in another comment.

[@MMS-PowerBI]

Thanks for sharing!