Joannasmile
New Member
Hello! Need small help. Not sure if it is possible to create such a chart in Excel.
I have such information. Particular employee opened SickLIst on Day 1 and closed it on Day 2.
I need to create a schedule that would look like this, where evey row belong to emploee
I thought That it is doable with Pivot Table, but not sure how to add Month dates to the column section (as each employee have tehir own dates)
Maybe you could suggest how to do it, to avouid creating such scheduel manually
I have such information. Particular employee opened SickLIst on Day 1 and closed it on Day 2.
I need to create a schedule that would look like this, where evey row belong to emploee
I thought That it is doable with Pivot Table, but not sure how to add Month dates to the column section (as each employee have tehir own dates)
Maybe you could suggest how to do it, to avouid creating such scheduel manually