Here's my data: (Table: EmployeePlan)
Code:
EmpID     Plan      Status
abc123    PlanA     A
abc123    PlanB     D
abc123    PlanC     A
xyz789    PlanA     D
xyz789    PlanB     D
xyz789    PlanC     A
...
where Status "A" means an employee subscribed to a certain plan and "D" otherwise.

I have created a GridView in ASP.Net, normalising the data by the...