Need help with Excel formatting

Check out this thread that has solved you problem : Excel Sheets formatting - need help - #2 by jack.chan

Again You have created Multiple Duplicate topic : How to remove duplicate entries from excel file - #4 by Sami_Rajput

Regards
Gokul