question

I have an excel file with lakhs of records my challenge is copy/paste the row header i.e. ABC to limited rows and remaining rows with DEF as per the blank spaces left under that different row headers respectively. If I have company Id's I would have fixed them but there are duplicates. Is there any possibility to work in SQL. I think its easy to write a macro in excel to fix. Appreciate in advance for the concerns!! Input Output CompanyName ID Company Name ID ABC ABC 626293 626293 ABC 626292 626292 ABC 626296 **626296** ABC 626296 **626296** ABC 626294 **626294** ABC 626294 **626294** ABC 626294 **626294** ABC 626293 626293 ABC 626292 626292 DEF 637862 Totals for ABC (9) DEF 637862 DEF DEF 637862 637862 DEF 644451 637862 DEF 644447 637862 DEF 610783 644451 DEF 617179 644447 DEF 622365 610783 DEF 45121 617179 DEF 480844 622365 DEF 617712 45121 DEF 631613 480844 DEF 639732 617712 DEF 638550 631613 DEF 619575 639732 DEF 638547 638550 DEF 619573 619575 638547 619573 Totals for DEF (17)