Hello everyone, I have the following table StudentNumber ID Name Last Name 12345 CSE890122 Carl Smith 78946 SJE901205 Susan Johnson 63796 CSE890122 Carl Smith 36978 EME750615 Eddy Murphy 42135 SJE901205 Susan Johnson And I have the same student under different student numbers, for example, Carl Smith under #12345 and #63796 and Susan Johnson under #78946 and #42135. What I'd like to have is StudentNumber1 StudentNumber2 ID1 ID2 Name1 Name2 LastName1 Last Name2 12345 63796 CSE890122 CSE890122 Carl Carl Smith Smith 78946 42135 SJE901205 SJE901205 Susan Susan Johnson Johnson Is it possible to transform it that way so that if ID is duplicated, another column is created with the different student numbers and all the related data? if that makes any sense... Any idea will be greatly appreciated. Thanks!!
... View more