How do I avoid an export to Excel combining multiple cell values into one?

Dave Jobling
Dave Jobling ✭✭✭
edited 04/02/20 in Smartsheet Basics

I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values.

When I export the sheet data to Excel, those multiple values get combined into a single value. For example:

A cell in the sheet contains three category values: Content labeling, Usability, Knowledge management.

The equivalent cell in the spreadsheet contains a single value: Content labeling Usability Knowledge management.

I start off with 15 categories to choose from. After the export, because of the many different ways the drop-down values can combine, I end up with ~40 categories. This makes my reporting meaningless.

Is there a way to stop the export from combining the values?