Thanks for the response. I think my problem may be a little bit more complex. I could transpose 22 rows of data for each, but that doesn't seem so efficient because each resource may only work on a given project for one or two months rather than the entire period.

I've started hacking away at this manually, but any advice to speed it up would be appreciated. Thanks