How to expand a list

Hi there,

I have a spreadsheet that holds details about different organisations. I need to include names of employees in this but only want the information be shown if the user needs to see it, otherwise the spreadsheet would be very long. So I have one row per organisation, and want to have a box at the end of each row that can be clicked on to expand to see employees details.

I have no idea how to do this though and was hoping someone would be able to help.

Thanks in advance.

If you have one row per organisation
Then I'd list the employees in a single cell separated by commas.

Thanks, but that wont work as I have email addresses, job roles and locations to include for each employee as well.

I've found a solution using groups that will work for the time being. Thanks anyway.