On Nov 18, 12:05*pm, Sydney wrote:
Sorry - I don't see an "advanced" and my dummy data in a new sheet is
not doing the same thing. I really don't want to have to remake this
whole file from scratch, but I can't share the actual data. I was
really just hoping someone could tell me if this is a question of
settings or something Excel just can't do. But now that I've tried it
with a fresh workbook, I know that Excel CAN do it. I just don't know
why it won't do it in the original document.

Sorry - by "this file" I mean the thing I have to do for work. I have
a dummy data file ready to go - I just don't see how to attach it.