help with extracting data from table

I have a big table with much data.
From this data I need to create reports based on the first column of the table.
Is there a way to do this without using a pivot table or a macro?
Commands like VLOOKUP only return the first found record.
Sample file attached and help much apreciated.