[SIZE=3]Potentially, you might be able to do something with hiding key field columns when exporting from the summary window. Hidden Keys are exported as hidden columns in Excel. /SIZE[/FONT][FONT=Calibri][SIZE=3]However, hidden columns from the table are not available in the target file.[/SIZE][/FONT]
[SIZE=3]Create an Excel workbook with sheets called ‘data’ and ‘monarch’ for example. The ‘data’ sheet would copy data from the monarch sheet. The formula in cell A1 of the data sheet would be =monarch!A1, cell A2 would be =monarch!A2 etc[/SIZE][/FONT]
[SIZE=3]If this is a requirement for a larger audience then there are several features in Monarch ES that would give your users more control. /SIZE[/FONT]
Edit: I missed Steve's mention of using summaries altogether. Just read it now.
Sorry all, I'm a bit late to the party today.
There is a way that you can do this with Monarch. I rely on this technique frequently. And as your intention is to export tabular data structures, it should work for you too.
Instead of exporting from the Table, build a new summary (with subtotals and without suppressing duplicate values). First add all of the fields that you need as keys and/or items. Now add and position the fields that you want included but not displayed. Go to the Display tab for those fields and elect to hide them.
Now they'll be included as hidden columns in Excel exports.
This works best for smaller data sets (fewer columns), and from what you've described it ought to do the trick.