I have data as follows: We call this table Client_benefits
Client_name, Income_type, Frequency
Joe Smith SSI Month
Joe Smith Work Week
I would like an out put row as follows:
Joe Smith SSI Month Work Week
Rather than currently I am getting duplicates but would like to see one row if possible.