Summary Time Sheet for all Employees

[prkhan56]

I am using Excel 2010 and have the following problem.
I have attached a sheet showing the Original Data and the Output Sheet showing the desired result required through a macro please.
I have colored the Cells on both sheets for sake of easy understanding.
I wish to have data for all Employees one below other as shown in the Output Sheet. Currently it shows data for Emp1 only which I have done through copy paste and then deleted Rows where value was 0 (zero) in Col H (Hours) on Output Sheet.
Please note the following:
a) The Employee Names will start from F4 onwards … at present till AX4.
b) The Employee Names will increase or decrease
c) Data will start from A11 downwards.
d) Only Values greater than 0 (zero) should be transferred to the Output Sheet under each Emp Name.
e) Column I on Output Sheet (EOM) will show the last date of Month taking the Value of Cell A2 on Original Sheet.
f) Col D, E & F on Output Sheet will show NA for Category Names 2 onwards.
g) All Category names are merged from A to E Columns (at present Category 1 to Category 5)
Any help would be greatly appreciated.

TIA
Rashid

[oeldere]

First of all, don't use merged cells.

You get trouble with it sooner or later.

Maybe you can put your data with VBA in a table.

Then you are flexible for the combinations you want to make.

[prkhan56]

Thanks for the suggestion.
Suppose If I remove the merge the Category names move to Col A.
Now can a macro do the output sheet?