Time Series Template: Re-order Codes in dropdowns

[AmberSJones]

It would save time to have the list of method codes in the drop down menu under the "Method Code" column in the "Data Columns" listed in alphabetical order instead of the order of how the method codes were listed in the "Methods" tab.

[SRGDamia1]

I'm not sure if this can be done in excel. Well, it could be done, but I'm not sure it can be done without using an extra set of hidden columns and formulas.