My data captures members purchasing history for a category of products. Typically a member will be buying product X for a number of months but I am interested in those members who moved to product Y and when that happened. My data looks as follows: I would like to pull a list of all member numbers and the first date