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

Closed
Gowria17 Posts 1 Registration date Wednesday March 1, 2017 Status Member Last seen March 1, 2017 - Mar 1, 2017 at 03:08 AM
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