I'm a beginner, is there a way to automatically combine multiple rows belonging to a single ID number into one row containing all of the information? I have an excel file that looks something like this (just much longer with multiple ID numbers/names):

ID Number - Name - Service Type - Cost

1045     - Johnson   -  A  -  $10

1045     -  Johnson  - A - $10

1045     -  Johnson  - B - $20

1045     - Johnson  -  C - $30


I want to combine all this info for person "Johnson" (and all the other people in the file) into a single row for each individual person that looks something like this:

ID Number - Name - Service A Cost - Service B Cost - Service C cost

1045   - Johnson        - $20   -    $20   - $30

Is this possible?  