Moving data from Rows to columns and delete repeated rows

Need help removing duplicate rows and move other data frm rows to columns.xlsx
Hello all,
I am attaching a sample excel sheet showing what I need to do.
In the first tab, I have a list that includes duplicate rows (first column only). I want to remove those duplicate rows but I don't want to lose the data in the following columns which can be unique or duplicates as well.
Please see the desired result tab in the sheet to get an idea of what I am looking for as the end result.

Keep in mind that the actual source file I am working with could have up to 50000 row, and the expected results could be around 2000 rows. So nothing can be done manually.

Thanks all in advance,
Mike