Thank you for the replies.

Both solutions did work. However, the data I'm working with is slightly more complex than my simple example. My main data table is a transactional table...