Concatenate w/out duplicate values

[coryanthony]

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 

[Bren_Spill2]

@coryanthony - change the Action for workspace to Group By

[coryanthony]

@Bren_Spill2  - Since i still need to concatenate the [Workspace], that workflow will not work. I don't want to group by workspace. I need one row per date. 

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/Remote.

[Bren_Spill2 · Accepted solution]

@coryanthony - apologies. I misunderstood the request. Try the attached

[coryanthony]

@Bren_Spill2  You're awesome! Thank you so much. I see the logic now.