I am a little confused on what you are asking here.
Do you have multiple rates for the resources over the 12 month period?
Do you want to view the total cost for each resource based on rates and hours?

If you just need the rates for all resources and have only a single standard rate for each, can't you just pull the data from the resource sheet view. You can select and copy to excel.

Please share more details about what exactly you need.

Cheers!
Leah