How to duplicate value in column 2 when value in column 1 is the same (one workbook)?

[JoshuaElphee]

I have a workbook where column 1 may have multiple duplicates, and some rows are filled for column 2,3,4 etc.   Whenever column 1 is a duplicate, I need to duplicate the value shown in column 1 where that row is not duplicated.  ex.:

Column 1	Column 2	Column 3
ABC	Alphabet	Gold
1hn	Mixed	Silver
470	Numeric	Platinum
ABC
ABC

Within this workbook, the two duplicates at the bottom need to pull in the same value that is in Column 2 and Column 3 in row 2 to show: 

Column 1	Column 2	Column 3
ABC	Alphabet	Gold
1hn	Mixed	Silver
470	Numeric	Platinum
ABC	Alphabet	Gold
ABC	Alphabet	Gold

There are many other columns that must not be touched (may be different between the three rows).  What is my best route towards duplicating these values here with minimal waste?

[Manoj_k]

Hi @JoshuaElphee hope the below formula helps.

[flying008]

Hi, @JoshuaElphee 

FYI. [If Column2 and Column3 have some blank in cell, maybe you need use Data Cleansing tool before sort. ]