I would like to create a new dataset with only 1 row for each ID.  I would like the first non-null value from the "field" variable to be placed into a new variable called "Animal".   I have included an example of my orginal dataset and my desired dataset below.  What would be the best approach to create the desired dataset?  Thanks in advance for any help you can provide.   Original Dataset ID Field 1   2 dog 3   2   1 cat 3 dog 1 cat 1   4 hamster 2 dog   Desired Datset ID Animal 1 cat 2 dog 3 dog 4 hamster     ... View more