Formula to reorganize data

[rizmomin]

Hello:

Please refer to attached file.
I have hours for each employees for each day in the form as shown in Sheet1 D2:AF32
I need get this data in the format as shown in Cell B50:E down
Basically, need to go thru each day data and get employees who worked and their hours

Let me know if you have any questions.
Thanks.
RIZ

[bebo021999]

See attachment

[AlKey]

For the HOURS use this formula in E50 and copy down

Please Login or Register  to view this content.

[rizmomin]

HI Bebo and Allkey:

Both solution are great..
Thanks a lot, will do more testing and let you know if any problems.
Riz