will try to make my question as clear as possible.

I am working with the Salesforce Connector and Google Sheets.
The report pulled in updates every 4 hours. In Google Sheets I use different formulas to get data I need (usually I wanna know how many records I have for each person, within a time frame etc.) -> So I use Sumifs or Countifs. No problem so far.

However, I want to take it a step further and use a formula to not just show the count of records for a person (or the sum of the values), but rather I want to reflect the records.

For example:

Name: Susan Miller

Count of Open Opps: COUNTIFS Formula (no problem)

Sum of Value of Open Opps: SUMIFS Formula (no problem)

Next: Should List all of these opps in separate fields (does this work with array formulas? How do I do this?)