I am new to queries in Excel and can't seem to find another post with my issue, though I suspect I am not using the right terms.

I have queried a data table, and certain columns in the query contain a list of 1-4 different classifiers. When editing my query I can preview these lists, but in my Excel book I only have the text "[List]" for these entries.Screenshot 2023-08-08 155505.pngScreenshot 2023-08-08 161805.png
Is there a way to have those lists populate, either as separate entries, or concatenated in the same cell?

Thanks in advance for any guidance you can share!