Column C of the App Totals tab in the Google spreadsheet below contains a formula, also noted below, that allows data to be transformed into separate columns.
This is a great start, but I would prefer to have a vertical list, but to remain on the same row, all inside the relevant cell.
Here is the online spreadsheet:
Here is the formula used in C2:
=transpose(FILTER(Apptracker!D:D&", "&"#"&Apptracker!F:F&", "&"on "&TEXT(Apptracker!S:S,"ddd MM/DD/YYYY"),Apptracker!H:H=B2,NOT(ISBLANK(Apptracker!D:D))))
Assistance in making this happen is greatly appreciated.