I have a sheet with property managers and the id of the properties they manage:
pid name email 34721 Aron Hall email@example.com 35173 Aron Hall firstname.lastname@example.org 35057 Bobby Blue email@example.com 34689 Bobby Blue firstname.lastname@example.org 34621 Bobby Blue email@example.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 firstname.lastname@example.org 34721, 35173 Bobby Blue email@example.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 ?