I have scattered data in Columns AS to BS (2 to 41786 rows). I would like to delete all the blank cells and move all the data to the left (starting from AS column).
I am not good with macros/VBA etc. Just trying to learn and have recently added 'developer' in my Excel (2007).

I have searched for this online and though I see some questions/solutions on this, I am unable to amend it to work on my data.

Can someone help me please?
Thanks in advance!!!