I have a Google Spreadsheet that lists donations given by constituents with a unique account number. Several constituents have made more than one donation in a given period of time listed separately. I would like to filter the list of constituents and include each of their gifts in the same row as their account information.
In the attached spreadsheet, Sheet1 shows a sample of the data, and the second sheet shows the desired results as I would like them displayed. I imagine some sort of array formula filter could accomplish this, but I'm at a loss how to construct it. Any help would be appreciated.
I created an example file with expected outcome: Consolidate List of Similar Data into Single Row