Hi Darcy,

If you take Tech Support's suggestion and create a drag-and-drop departmental comparative, you'll see that it uses the =RNGMERGE() function to generate the column for the departments you have selected.

It's a fast way to generate a model.