I understand now . I believe the only way s to use a proxy collection between your original collection and RadGridView. For example based on your original table , you may programmatically create a new table having data transposed the way you need it . Then you can feed this table to the ItemsSource property of RadGridView and let it auto-generate columns.
In case you have troubles implementing this approach let me know so I can assist further.
the Telerik team