All the information coming from one table, no don't have ID, I just used NULL as an example, let's say ABC also had NULL value for Product then it should show up as "NULL" and count of NULL values

For example, If ABC company has NULL under product and REC_COMPANY is "FL" then it should give me count 1 and REC_COMPANY "FL"

Thanks