My advice is to use separate sheet for maintaining all contacts (or whatever info you have here). There every contact will be on single row - i.e. a you have table structure there. (P.e. Sheet Contacts with table tContacts which has columns ContactGroup, Address, Phone, Supervisor...)

Now when you need for some purpouse info in format displayed in your attached file, you design a report sheet, where you read all needed info from table tContacts. You can design this sheet to display all contacts (but depending on number of contacts this report can grow huge), or you can let user to select some subset (p.e. ContactGroub) to be displayed.