there are 2 types of nulls - one with just a data value that is null and another where there is not a record in the data set - when you split across the rows you may be running into the second type - here is something to try -