CASE Statement To Repace Null Values in Cascading Fields
<p>I am trying to build a CASE statement to handle the table below. </p>

<p>If Service1 is NULL I would like the value in Service2 to replace it. If Service1 and Service2 are NULL I would like the value in Service3 to replace it, etc ... etc ...</p>

<p>I would like to repeat this action on each field so they table is as compressed as possible. </p>

<p>I managed to build a CASE statement but I had duplicate values, as the value moved from Service2 to Service1 but also remained in Service2. I need all of the values to shift based on NULL values so the same values remain on the row but they are as compressed as possible across the columns. </p>

<p><a href="https://i.stack.imgur.com/vT878.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vT878.png" alt="enter image description here"></a> </p>