In my case i have a database of more than 30,000
How do i get the duplicates in one row and the last three criteria of puting x in one row of one person Like Manmeet abc 000 - - - x x x
You can use Excel's built in Table and Pivot Table functionality for this.
The resulting Pivot Table will have the Count (i.e. 1) instead of "X" for the values in your Web, ISCI and Lenders columns. If you really want it to be "X" (or someother letter/symbol) you can use a custom number format for that column.
One extra benefit of this solution is that as you add values or update your table, the Pivot Table will update, so your summary will always be current.