I thought it would be a simple task to get some fields from an existing table into a new one containg a few fields of constants.
It sounds like you want to use looked up values to get constants and store them in a primary table that you will be exporting.
Here's a training video on lookups, there's actually a few parts:
Having all fields in the same table is the best way to get compatibility when exporting. I'm not sure I understand completely to make recommendations, so some screenshots or sample files of your export goals may be nice.