Sorry, I am new to excel macros and was not sure were else to turn. I am not sure the title quite fits this but here goes.

I have a spreadsheet, in it are 6 columns
A = Name
B = Category
C = Data1
D = Data2
E = Data3
F = Data4

Here is my problem, I made a sort that sorts all this data by name, and all names are written the same so there are no problems there. There are a total of four Categories(Column B) - and then data for each category. My issue is some people have only one or two categories because they have no data for the month, so thus no category listed. For reports we need to have all four categories listed for each person.

So my question, how do I do this. If there is a category missing, when it is added all data for C through F will be "0". But how do I add this so that reports made from this data will have all for categories even if for some people they currently arent listed.

Any help would be great, I got some of the basics down, but I couldn't really find anything like this in google.

Thanks a bunch,

Jesse