This is what I am starting with:

Column A contains a list of manager names. Each manager has his name listed
once in colunm A.
Column B contains days of the week. Each day of week is listed once per mgr
in colunm B.
Column C contains empolyee names. Each employee is listed more than once
depending on the number of days scheduled.
Column D contains a number indicating hours scheduled.
It looks something like this:

MGR1 Monday Jim hours
Joe hours
Pat hours
Tuesday Jim hours
Joe hours
Mgr2 Monday Tim hours
Tuesday Cal hours
and so on......
I need it to look like this:

MGR1 Monday Jim hours Tuesday Jim Hours
Joe hours Joe Hours
Pat hours
Mgr2 Monday Tim hours Tuesday Cal Hours

and I have no idea how to accomplish this with a macro. Can anyone provide
some assistance? Thanks in advance!