Suppress repeating values
Here, I have tried and tested it and it gives the output you wanted (this was tested in Oracle):

SELECT
    CASE
        WHEN dr &lt;&gt; 1 THEN NULL
        ELSE demand_ind
    END demand_ind,
    batch_number,
    debit_status,
    customer
FROM (
SELECT
    demand_ind,
    batch_number,
    debit_status,
    customer,
    ROW_NUMBER() OVER(PARTITION BY demand_ind ORDER BY rowid) AS dr
FROM test2
) test3;