I want to achieve the following transformation:

**Sample Data**

```
SELECT NumWURm,ReportAText,ReportBText,ReportCText,ReportDText,ReportEText,ReportFText 
FROM t_SchFacility 
WHERE  FacID IN (483,485)

```

Result:

```
NumWURm ReportAText       ReportBText   ReportCText ReportDText ReportEText ReportFText

3       Report On venue   Warm Up       Photo       Get Set     
2       Report On venue   Warm Up       Photo           

```

**Desired Output**

I want to to get the common column values to be shown as it is, in case the values differ, I want to show some default text.

```
NumWURm ReportAText      ReportBText    ReportCText ReportDText   ReportEText   ReportFText

3       Report On venue  Warm Up        Photo       Default Text        

```