I'm trying to organize data in excel to take a list of volunteers and group or list them by assigned positions. I have attached an example of what I'm looking for but I'm not sure how to do this. I was originally thinking pivot table and now wonder if Macro/VBA which I don't know to well??? Any help on this would be appreciated.
