```
=IF(COUNTIF('PRDA Data'!S$2:'PRDA Data'!S2,'PRDA Data'!S2)=1,'PRDA Data'!S2,"")
```

This formula is used to eliminate the duplicate from another sheet. Now the issue is Duplicates are removed from the above formula. But when I drag wherever the duplicates are found this gives a blank row. How to eliminate the blank rows and make this as a continuous row update.

Image with the issue i am facing:

Here is my Data how it looks Sheet 1

I have added 2 images. Sheet 1 has duplicate data and the final sheet needs to have unique value data.

Updated with a video

And this is formula i am using

```
=IFERROR(INDEX('PRD Data'!S2:'PRD Data'!$S$60,MIN(IF(IF(ISERROR(MATCH('PRD Data'!S2:'PRD Data'!$S$60,$K$4:K4,0)),'PRD Data'!S2:'PRD Data'!$S$60,9^9)=9^9,9^9,ROW('PRD Data'!S2:'PRD Data'!$S$60)-ROW('PRD Data'!$S2)))),"")
```