I needed to include a left join in the dataset query and create a matrix. The left join was required so I can extract the full set of values to be used for the column headers. For the records that were null I took the following steps

Right click on row of the Matrix, select Edit Group

Select Filters tab

Expression: I chose the Field value

Operator: !=

Value: =nothing

This will filter out rows with a null.