Depends on how the rest of your data set look like. How did you get this layout? It looks like a transpose that went wrong. I would prefer a normalized table design, which is more flexible to most reporting requirements. That would mean to transpose columns to rows, having one year, and one colour column. For your particular example it would be a quite simple use of the coalesce () function.