Table with data in columns A-N. Data in column 'M' contains CSV data.
Using this query can return data, need what's in 5th returned column (E) to be split into additional columns through one command. Cannot do this separately manually...
=QUERY(scores,"select A,H,K,N,M WHERE N is not null and M is not null order by K ASC, N DESC, H ASC, A DESC")
Output has to be obtained using QUERY function, as its pulling from a named-range, from a data set I cannot modify. The other columns may contain commas and are not required to be split up.
Currently the column required to be split comes from M in the original named range. When this query runs, the data needed to be split is in the 5th column (E).
Not clear how to augment what you've suggested to fit this. I was able to use your example of offset to hit the named range, but that omits the necessary limits imposed by the SQL select portions of QUERY.