Hi,
I use a large spreadsheet as a shift roster planner for staff. After the first couple of colums that contain name, I/D number etc for each individual, each column represents one day. Each row represents one individual.

The cells contain what shift that person is doing on each day ( D, L, N or R) or if they are on a particular course, the name of that course.

I'd like to be able to create various reports from the data.

One being for each individual, to show what they are rostered to do each day for the coming 6 months, but not in one long line - ideally broken down into weeks.

The other is to show on a particular date, which individual is doing what shift, or course, grouped together by shift or course.

It's probably a simple task - but I can't figure out how to do it - anyone able to help me please?