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