The requirements are very much unclear. Based on the limited information available, the best solution I can think of is to use query() to aggregate the data by a key column using a group by clause.
“If you ask a vague question, you’ll get a vague answer.” How do I ask a good question?
You may Also Like:
None found
