How to put the information into one row and limit the duplications?
I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information as well. I want to be able to keep the staff records into one row as much as possible (exceptions where they have multiple same contact phone number type or multiple emergency contact is fine to display on more than one row but otherwise should be shown in a single row if they have one work phone number, one personal landline etc).
In my report that I build I have created the custom columns for personal landline, personal mobile phone, work mobile phone, and work landline. What it currently does is, it will show the person on multiple rows even if they have just one work mobile number and one personal number. It does this by having one row showing the personal mobile phone and the work phone blank, then another row to show the work mobile but the personal mobile blank (will have more rows if they have other phone types). For this case I would want it to show on