Remove duplicate fields and have them null
15:03 08 Dec 2025

Is there anyway to remove the duplicate rows and just have blank fields like below? Thanks.

Have:

enter image description here

Want:

enter image description here

Final Join:

SELECT DISTINCT MST_VISITS.ID_NUM
    ,MST_VISITS.MST_PROVIDER
    ,MST_VISITS.ADMIT_DATE
    ,MST_VISITS.LAST_VISIT
    ,MST_VISITS.TOTAL_UNITS

    ,LESS_7_SUMMARY.PROVIDER_NAME AS LESS_7_PROVIDER_NAME
    ,LESS_7_SUMMARY.SERVICE AS LESS_7_SERVICE
    ,LESS_7_SUMMARY.VISITS AS LESS_7_VISITS

    --,BETWEEN_8_30_SUMMARY.PROVIDER_NAME AS BETWEEN_8_30_PROVIDER_NAME
    --,BETWEEN_8_30_SUMMARY.SERVICE AS BETWEEN_8_30_SERVICE
    --,BETWEEN_8_30_SUMMARY.VISITS AS BETWEEN_8_30_VISITS

    ,BETWEEN_31_180_SUMMARY.PROVIDER_NAME AS BETWEEN_31_180_PROVIDER_NAME
    ,BETWEEN_31_180_SUMMARY.SERVICE  AS BETWEEN_31_180_SERVICE
    ,BETWEEN_31_180_SUMMARY.VISITS AS BETWEEN_31_180_VISITS

    ,BETWEEN_181_365_SUMMARY.PROVIDER_NAME AS BETWEEN_181_365_PROVIDER_NAME
    ,BETWEEN_181_365_SUMMARY.SERVICE AS BETWEEN_181_365_SERVICE
    ,BETWEEN_181_365_SUMMARY.VISITS AS BETWEEN_181_365_VISITS

    --,PRIOR_180_SUMMARY.PROVIDER_NAME AS PRIOR_180_PROVIDER_NAME
    --,PRIOR_180_SUMMARY.SERVICE AS PRIOR_180_SERVICE
    --,PRIOR_180_SUMMARY.VISITS AS PRIOR_180_VISITS
    --,ROW_NUMBER() OVER (PARTITION BY MST_VISITS.ID_NUM ORDER BY MST_VISITS.ADMIT_DATE) AS RN
    FROM MST_VISITS
         LEFT JOIN LESS_7_SUMMARY ON MST_VISITS.ID_NUM = LESS_7_SUMMARY.ID_NUM
        --LEFT JOIN BETWEEN_8_30_SUMMARY ON MST_VISITS.ID_NUM = BETWEEN_8_30_SUMMARY.ID_NUM
        LEFT JOIN BETWEEN_31_180_SUMMARY ON MST_VISITS.ID_NUM = BETWEEN_31_180_SUMMARY.ID_NUM
        LEFT JOIN BETWEEN_181_365_SUMMARY ON MST_VISITS.ID_NUM = BETWEEN_181_365_SUMMARY.ID_NUM
sql sql-server