I have an input sheet with a lot of names in Column A which repeats (Maximum 3 times) and rest of the cells (from column C) are different.
I need to generate a sheet with unique names and rest of the cells transposed.
INPUT SHEET
Employee ID Date Of Joining Effective Date...