Hi,
Although with the given format of the data, its very difficult to come up with reports that'd make sense.
I have recreated a sample data. (Me bieng from BPO background helps)
Hope this helps...
You'd have to change the format into a more vertical one as mentioned in the attachment
Then by creating a Multi-level pivot, you'd be better off getting reports as and when you need by changing a few variables
Let me know if this is not what you had in mind
Thanks
Bookmarks