I have a problem where some database items return multiple values in a column that can be seen onscreen by expanding the field. I need to treat these values as individual items when utilizing the data later on. I thought an array would work but I may not understand what an array is for, or maybe, just not how to set it up properly.
This is what I'm seeing in the database for "current value":
So can I do anything to separate this out, or do I have to do something prior to obtaining the database information from my spreadsheet?
Thanks in advance, to anyone who can help!