Excel Macro to Get customised data

I have a usage sheet with 5 columns. First column contains a unique number, 2nd contains a Name, 3, 4, 5 are goals, target, progress resp. These 3 columns shows how many time the user has visited the page (ie goal, target, progress page). this may be one or empty. There are multiple entries for each name and code. pls see the attached sheet. I need to take the count of goals, target, progress for each code. How many non empty cells are there under column 3, 4, 5 for each code in column 1.

Please see the attached sheet. in short, If i give a sheet with table A, i should get another sheet with table B.

I have a huge amount of data and manual processing will not be possible. Please help immediately.

Thank you very much.