#127 — Concatenate Data Within Groups into Text

Problem description & analysis: Here below is a data table: Task: Group the data by Dept, and concatenate the names within the same group into the same row. Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group(Dept;~.(Name).conc...