EDIT: below can be done on adobe campaign classic but i suppose something similar you could have too
if you want to do it manually you can export the working table. Make sure the workflow is in pause state or enable results of interim population
Right click on paused transition or transition you want to see the data of:
then right click and choose Export
Hope this is what you wanted
If you want to do it automatically you can use data extraction activity which has same settings as the manual export above
This will save the file on the server where the adobe campaign is running so either you save it (file transfer activity) on sftp where you can access it or you need to have access to the server folders. If you do not have this option there is one workaround (not recommended) where you can send the file as attachment in the email.