I have similar challenges but with a lot more columns. for you're problem there is a good article here: http://www.codeproject.com/KB/database/Pivot2Columns.aspx?fid=1532143&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=2844387

You could also use a simple pivot query twice (once for each item) and join them.

You could also try what I tried and create a relationship in the data so that each extra group of columns is actually a band (child band of Red would be Blue, child band of Blue would be Green.), then display the bands horizontally, ensure they are all expanded, get rid of +/- buttons, etc. This actually worked well for small datasets but for large ones it bombs when calling ExpandAll.

Final alternative (which the one I'm stuck with right now) is to try to turn the vertical dataset into a horizontal one manually using a datatable and use groups to manage the column groupings.

If you figure out a better way please do post.