We have Employee training data in a Google 'Form Response' spreadsheet which ranges from
JQ1000. This spreadsheet is automatically populated when a Google Form is completed but it is difficult to look at so I want to tidy it up.
The Form Response spreadsheet is populated with the Training Event, the date of the event and the employees who attended that event.
To tidy it up I thought it best to use
Query but some employees name might appear several times in different columns and different rows.
I don't want to have to write
'Select * WHERE C = 'David Bowie' OR D = 'David Bowie' OR E = 'David Bowie'" and so on out to column
Can someone help me with a simpler formula?