Create Column for Each Resource

I have a requirement to export an MS Project file to Excel for import to another application.

The request is to have a unique column for each resource required in the project by Task.

So a line of data for a task would include:

Task Name - Work Estimate - Resource A Work Estimate - Resource B Work Estimate .....

Build A 20 hrs 10 hrs 10 hrs


Creating the column as a Text Column is easy. Customizing that column to include the work demand of a specific resource is where I am struggling.

Thanks in advance.

I am happy to provide the data in a different format if it helps explain my request.