It would be great to be able to group results into a tree view by dragging columns to a grouping pane (just like in Qutlook).
For investigating data grouping is one of the most powerful tools.
So if you have a result with columns col1, col2, col3 you would drag e.g. col1 to the grouping pane and then see a list of distinct values of col1. Each value is a tree node. Once you expand the tree node you will see the result items belong to that value of col1. Certainly nested grouping (col1+col2) should be supported as well :-) Addtionally it would be great to provide some aggregate values (at least count) but maybe even average for some other column. There should be ready to use controls available that allow to do that out of the box.
Thanks for the greate LinqPad application. I took the challenge - and WON! Now my life is easier.