To group fields on a report in Insight, follow the below steps:
Go to Settings then go to All Reports and find relevant the report.
Click the three dots then click Manage then click Add.
Click Calculation.
Select the data field you would like to add, such as Home Full Address - this will then get added to the Calculation Text Section.
Enter || ', ' || (if you would like a comma to separate the fields) if not || ' ' ||
Click on the next data field, such as Post Code.
Click Save.
