Hello,
I want to concatenate a field but prefer not to have duplicate values. Grouping by [Date] and concatenating [Workspace]
e.g.
| Employee ID | Employee Name | Date | Number (unit) | Rec. sales order | Location | Workspace |
| 1114 | John Smith | 1/2/2023 | 8 | | US-NY-YK | |
| 1114 | John Smith | 1/3/2023 | 2 | 512713 | US-NY-YK | Client Office |
| 1114 | John Smith | 1/3/2023 | 8 | 377671 | US-NY-YK | Client Office |
Desire output:
1/3/2023 | Client Office. (Currently getting, 1/3/2023 | Client Office, Client Office.
e.g.
| Employee ID | Employee Name | Date | Number (unit) | Rec. sales order | Location | Workspace |
| 1114 | John Smith | 1/25/2023 | 2 | 377655 | US-NY-YK | Client Office |
| 1114 | John Smith | 1/25/2023 | 7 | 377671 | US-NY-YK | Client Office |
| 1114 | John Smith | 1/25/2023 | 1 | 576465 | US-NY-YK | Work from Home/Remote |
Desire output:
1/25/2023 | Client Office, Work from Home.
Current output:
1/25/2023 | Client Office, Client Office, Work from Home.
please HELP. Thank you
