Feb-09-2020, 08:57 PM
You could create a set extracting all the unique IDs.
Then create a new dataframe and in a loop add every new column quering the old dataframe for every element in the set.
Then create a new dataframe and in a loop add every new column quering the old dataframe for every element in the set.