When exporting one-to-many fields in an Export, the Criteria window has an Order by function. While this is a useful function, it only comes into effect if you export 2 or more of whatever type of record you are trying to output. If I want, for example, to export a primary email I can order by "Is Primary?", but only if I export 2 email addresses. This adds unnecessary columns to my export (especially if I am, say, exporting addresses with multiple fields but only actually need the current address).

Documentation of this behavior:

• https://kb.blackbaud.com/knowledgebase/Article/52739

• https://kb.blackbaud.com/knowledgebase/Article/51049