Format Column in SharePoint List

Question

hello i have a lookup Column in my sharepoint list.
first list "Event" second list "Participants"

the second list is lookup field with the name and the additional field is the last name.
What bothers me here is that the last names are listed next to one another and not one below the other as with the first name.
The email addresses should also be one below the other and not next to each other.

I want to format it with JSON, can someone help me.

i add a screenshot, from my table.

thank you in advance

Answer 1

Hi @Aleyna Sahin ,
Per your description, you could have a try on the JSON code below
For lastname column:

{  
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
  "elmType": "div",  
  "txtContent": "=replaceAll(@currentField,',','\n')"  
}  

For email column:

{  
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
  "elmType": "div",  
  "txtContent": "=replaceAll(@currentField,';','\n')"  
}  

Before:

Test Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.