Yeah, I feel you on how frustrating this is. The only way we've been able to get the data in a format that works for us is to Export it to Excel and then use the Text to Columns function in data validation. This is why we try to avoid using the matrix option, because it often creates extra work for us.
------------------------------
Kelli Mahoney
Associate Director of Operations-Global Events
American Jewish CommitteeUnited States
------------------------------