I wonder if any one could help me with this case:
Exampled data
And I would like to split them into two separate tables/sheets
Splitting criteria for table 1:
Any contact (email) that their second-to-last record contains data (Event ID)
Splitting criteria for table 2:
Any contact (email) that: have only ONE row OR their last two records are empty
By last - I mean the oldest
Any one can help with SQL query?
M.
EDIT://
SplitTestData.zip