I have to ask why? just enter the DATA and then report what you need. So in your example you have Employee_Table (columns A:C) then a Data_Table that has EMP ID, Date, value(s)
Then you can use a pivot table, power query, or cell functions like FILTER() to create your "report" or whatever you need.
That all said, you could use this for the date column:
then highlight the other cells and double click the small dot/box in the bottom right corner