title: Move data to the leftmost blank cell with VBA
body: <p>In essence, I need an automatic way to move all cells the very left most blank cell.</p>
  
  <p>I've made an example:
  <a href="https://i.stack.imgur.com/BumgI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BumgI.png" alt="enter image description here"></a></p>
  
  <p>Example of unsorted data in the blue, how I want it to look when sorted in red.</p>
  
  <p>Like I say, the way it needs to be sorted is, in theory, by moving it left through blank cells until the cell on the left is not blank.
  I presume this would be a VBA solution, but I am unsure where to begin.</p>