Using Excel, I want to firstly list multiple occurences of an item from a column
And secondly I want to list the values in the same row from 3 colums that match the row in which the item was found in the first column, i.e.

A B C D

fred 1 3 6
harry 2 5 7
mary 3 6 8
sue 6 7 9
kerry 9 5 7
fred 8 9 5
martha 4 8 7

I want fro example all occurences of fred and the values;
i.e.

fred 1 3 6
fred 8 9 5

Thanks