I'm trying to create a pivot table view of data as you would get in excel but to be displayed in a ultrawingrid.
I have a collection class called PeopleToActivities. This is a collection of PersonToActivity classes.
The PersonToActivity class has three methods that I'm interested in ActivityCode, FirstName and Cost.
The dynamic data looks as follows:
ActivityCode FirstName Cost
A1 Bob 10
A2 Bob 20
A3 Bob 70
A1 Sue 50
A5 Sue 50
I'd like the data to be returned as follows:
A1 A2 A3 A5
Bob 10 20 70
Sue 50 50
The number of columns will need to be dynamically created as well as the rows.
I found the following post on here, however I couldn't get my head around the solution.
If anyone could provide sample code using the above in VB.NET I would be very grateful.