I have a sample sheet with about 1500 clients on the left and information and information across. However, on one of the columns it shows a list of all the subsidiaries of the client. Its the only column with multiple rows of information pertaining to the client. This column is increasing my list to over 18,000 rows. This information is necessary but I want it hidden so it only appears if someone clicks or something similar. See attachment. I would basically want to "hide" E2-16, making the information appear for example if someone clicks E1.

Please advise! If you have a better way to organize the information that would be great as well!

Sample Sheet.xls

Thanks in advance.