My response is based on the assumption that you’re using my Simple Event Logger SmartApp to log these events in Google Sheets.
You could create a pivot table that has the logged data on one sheet and the filtered data for each on separate sheets, but pivot tables can be really slow if you have a lot of data in the sheet. I usually try to avoid messing around with pivot tables in the active workbook (sheet file) because I’ve seen the logging process get messed up, but it’s rare and usually only happens if you have a lot of data in the sheet so it might be fine.
The easiest solution is to install an instance of the SmartApp for each switch which will allow you to log each device’s events in a different workbook.
Any additional questions about this should be posted to the SImple Event Logger topic.
If you’re using that other logging SmartApp then a pivot table might work fine, but you should post the question on that topic.