How to get entire row based on unique value of multiple column

[Closed]
Report
Posts
1
Registration date
Wednesday March 1, 2017
Status
Member
Last seen
March 1, 2017
-
I have to get entire row with unique values based on multiple columns as shown below, in that only one row(3 with same value as 2) is repeated and in output i will get three rows in another worksheet.Please help me to get the output using macro.

apple red chn
apple blue chn
apple blue chn
pineapple blue chn