making lists????

I am trying to take a table and make a few lists. I am not sure how to approach this. I want the results to be within the same excel workbook (not necessarily the same sheet). If it helps, the number of rows will always be the same in the first table (longer than this example). The second (result) table may have different quantities of results in the each column as cells are updated.

Also, note, that there are multiple rows that have similar information in column c.
----- see image upper table

tables.JPG

Would like to have the data above sorted as follows:

---- see image lower table

Please note, the result table would also be referencing the number in the adjacent cell.



Any help would be appreciated!