Shift data left to null cell

For anyone out there looking for a way to do this with a few simple clicks, I was able to get all data shifted left by the following:

In Power Query;

1. Highlight all columns that you want the data shifted left.
2. Select 'Merge Columns'.  Use equals sign as the separator (don't use semi-colon, didn't work this way). Select OK.
3. Then right click on your new merged column, and select 'split column'. 
   1. Split by the equals sign delimeter
   2. Choose 'split into columns' (under Advanced options). 
   3. Enter how many columns to split into (probably the same number of columns as original in case there's a row(s) where data exists in each one)
   4. Click OK.  
4. All of your values are now shifted left in the columns.