| 2 | any data | Log Text 2b |
I'm trying to get a query that gives me the following result
| A | N |
| PID | Entry Logs |
| 1 | Log Text 1a 'sep' Log Text 1b |
| 4 | Log Text 4a |
| 2 | Log Text 2a 'sep' Log Text 2b |
It will be really easy if the SQL API support the concatenation (or Join) as aggregated functions:
=query (A:N, "SELECT A, join('sep', N), GROUP BY A)
Is that something possible somehow else (without macros)? If not, is it something that Google might consider?
Let me know