If I have a [text-based] custom field and it has multiple values, when I retrieve those values, they come back [in a advanced list, at least] as a comma-separated list.   They should return as seprarate rows.

Returning them as a comma-separated list is over-simplified and makes it very difficult to actually deal with the individual values.  ...and it gets REALLY complicated if the values can contain commas.

e.g. a list that shows the last name, first name, and customerfield called "favoriteBands"  where the values for the field are "Beatles", "Cake", "Earth, Wind & Fire" would show:

"Smith",   "John",    "Beatles, Cake, Earth, Wind & Fire"

Imagine trying to separate the bands into their proper components.

It *should return three rows:

"Smith",   "John",    "Beatles"

"Smith",   "John",    "Cake"

"Smith",   "John",    "Earth, Wind & Fire"