Best way to record multiple client details for one record in SharePoint list

EmmaVR yes this can be done adding the following JSON formatting to each of the additional columns in advanced mode.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "style": {
        "white-space": "wrap",
        "width": "100%"
      },
      "txtContent": "=replaceAll(@currentField,';','\n')"
    }
  ]
}

which gives the following result:

For the main Contacts lookup column you can use the following JSON:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "style": {
        "white-space": "wrap",
        "width": "100%"
      },
      "txtContent": "=replaceAll(@currentField.lookupValue,';','\n')"
    }
  ]
}

Hope that helps.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)