I am using SelectMany to do some data transformation. It is essentially flattening some hierarchical data. The problem is that certain related data needs to be represented by the absence of data. Here is an example of what I'm doing: to do some data transform