I went ahead and gave them a pivot table. they aren't exactly happy, but are dealing with it. If anyone has any solution to add these as columns (other than copying, pasting, and editing the formula for each employee), please let me know. Thank you.