Please advice how to transform the original dataset to the expected output as shown below on SPSS Modeler?
It is expected to merge the values of all rows shared the same ID No.
Please advice how to transform the original dataset to the expected output as shown below on SPSS Modeler?
It is expected to merge the values of all rows shared the same ID No.


If SPSS syntax is availabel to you, the following aggregation command should do the trick: