MS SQL 2012：如果列包含0，则在SQL Shift列中显示左侧

I need to shift data(columns) to left side if first columns(left side columns) have 0 value and NULL should be added in right side columns. Once non-zero value found in any columns then 0 value in later column should remain as it is.I need to shift data(columns) to left side if f