In this video, we shall see that how we can remove extra blanks to Merge/Consolidate Data so that it is better structured using Power Query. We are essentially Shifting Values Up to cover up those extra Blanks.
Our result will be Dynamic such that in future if more Columns or Rows with Blanks are added, then our result will get updated upon Refresh.
Do Like, Comment and Share the Video. And Subscribe the Channel for more such Videos :)
Connect with me on LinkedIn - [ Ссылка ]
![](https://s2.save4k.ru/pic/FevrbZijCWQ/mqdefault.jpg)