oK Let me explain. Let say my table is something like this.

TS_USER_11 TS_USER_18

P1

P1 P2

P2

P1

P1 P1

P2

P1

NP P2

P1

I need out put like this . It will show how 9 rows are distributed across different providers (P1, P2, NP and Alternate)

P1 P2 NP Alt(Where TS_USER18 is not equal to null)

4 2 0 3