How to Drop a Row

Is there a way to create a new column that drops a row from a different column? Just like what is pictured below:
image

Yes! You can use the Lag() function to accomplish this.