Hi, thank you for contacting JustAnswer.com. My name is Russell. I will do what I can to provide the right answer to your question.
For such a task as the one you ask about, there is need to clearly define some aspects:
- What file format (or, what program name) do you need to export data to ?
- What SQL database system are you exporting data from ?
- 'multiple categories' meaning what? different data tables? (that would require some sort of merge operation) or perhaps different data records, or different data record types ?
In some systems of exporting data from a spreadsheet, the result can be a file where the data fields of the database are represented by text, separated by TAB characters. Would that sort of plaintext-with-tabs export format serve? or what?
There are several ways to do a data export from a SQL database system. The above points help define which means to a result will work best.