select distinct row
Read the SQL again
The first one reads all the rows- puts the result is Sheet
The second one reads the distinct rows - put the results in Sheet
The third one reads the recurring rows - puts the result in Sheet
The original question specified that if a name is recuring, all its records go into the 'recuring' sheet.
|