Assistance needed with a formula
 

i have a spreadsheet with multiple dates as headers and under each header
are names of users.
Like this:
1-Dec 2-Dec 3-Dec 4-Dec 7-Dec
emp 1 emp 4 emp6 emp 10 emp 2
emp2 emp 3 emp 4
emp3 emp10 emp 6
emp4


I need a formula that will give me every date that each emp falls under.


In separate

Assistance needed with a formula
 

Excel 2007 Pivot Table
No code, no formulas needed.
http://www.mediafire.com/file/3tvggidzzyd/10_15_09.xlsx