Concatenate select results of every column with " - " and with a new line

[AnonyDee]

I am using 2 tables PROJECT DETAILS and CONFIGURATION, They are joined with a key called Project Code

The PROJECT DETAILS contains apartment/building details and CONFIGURATION table contains details of each room in the floor.

I want to append the select result rows using a " - "

but I get wrong result as

2 BHK , 3 BHK - 22471803 , 33519300

instead of

2 BHK - 22471803
3 BHK - 33519300

I have tried with

'https://wa.me/?text=*' & encodeurl([Project Name] & ' a New Residential Project at ' & [Location] & ' by ' &[Builder Name] & ', a well known Developer in Mumbai (CAT A)' & ' Structure of the Building: ' 7 [Structure of the Building] & 'Plot Size:' & [Plot Size] & 'Possession: ' & [Possession] & 'Amenities: ' & [Common Amenities] & [Configuration Available] & 'Configuration: ' &
CONCATENATE(
SELECT(CONFIGURATION[Configuration], ([Project Code] = [_THISROW].[Project Code])), " - ",
SELECT(CONFIGURATION[Total Cost], ([Project Code] = [_THISROW].[Project Code]))
)
)

[1minManager]

So you're going to have to create "2 BHK - 22471803" in a column on one of those tables then use the Select() function to pull in a list of those.

Simon@1minManager.com