Hello!
I have a question - After grouping, could we concat the data in the same group into the same cell?
Below is an example to illustrate my question, do we have a method to automate it in Alteryx? Thank you!
| Before data manipulation | | | | | After data manipulation | |
| | | | | | | |
| Department | Year | Employee | | | Group | Employee |
| A | 2020 | Nancy | | | A-2020 | Nancy |
| A | 2019 | Joe | | | A-2019 | Joe, Nancy |
| A | 2019 | Nancy | | | B-2020 | James |
| B | 2020 | James | | | B-2019 | Adam, James, Brenda |
| B | 2019 | Adam | | | | |
| B | 2019 | James | | | | |
| B | 2018 | Brenda | | | | |
