Creating Unique ID from multiple columns

Hi experts,

I need help with the following. I have attached an excel file for reference. I have three fields, A, C and D. I want the unique ID in column B (highlighted). I want the Column B output as shown where the result should be unique and be a combination of column C.D.A . There should be a period in between as Orange.ABC.1 as a unique combination.


Thanks in advance
unique-ID.xlsx