I have data in one table as below:

Account_Id Month Source Code
12345 31/03/2023 New abc6789
12345 31/03/2023 Old abc1234

I like the data to be as below in teradata sql.
can anyone plz help

Account_Id Month Source code
12345 31/03/2023 New abc6789
12345 31/03/2023 Old abc6789

I am expecting the data as explained above