Jeez! I didn't know I would get so much dedication on this problem. Thank you both. I'd never used Coalesce before. Anyway, this query works great....

My table values got 'squished'. Here they are again, hopefully more readable. (I'll comma delimiter just in case)

Year, ID, SubID, Value

1990, ...