Change the layout of a result set
From Microsoft Query
Change the layout of a result set
When you insert fields or change the order of fields, your layout changes are retained while you work in Microsoft Query and when you return the result set to Microsoft Excel.