I have a sheet with property managers and the id of the properties they manage:
pid name email
34721 Aron Hall ahall@test.com
35173 Aron Hall ahall@test.com
35057 Bobby Blue bb@test.com
34689 Bobby Blue bb@test.com
34621 Bobby Blue bb@test.com
Is it possible to query into a new sheet tab each property manager and all the properties associated with them as one record instead of a duplicate record for each property a manager has ?
I'd like the new sheet to have rows like so:
name email pid
Aron Hall ahall@test.com 34721, 35173
Bobby Blue bb@test.com 35057, 34689, 34621
I know Google has its own query language but I'm not sure if my request if possible, if so what query functions might I use ?