Data exported from HR system does not come in format that can be put into pivot - help!

[TryingToLearnUK]

Hi everyone second post, so hope I get this right!

Attached is an example of the excel sheet a system gives when you select 'export to excel'. It (badly!) shows the employee name, leave type, leave dates and durations.

What I need to be able to do is either create a tab that has formulas to pull the key info, or ideally a pivot table. I have posted here and in the other forum as not sure if a pivot is even possible given the format the data is exported in.

The information I need to summarise from this data is:
- How many days leave in a set time period for each leave type (there are 15 types in total and days are listed in col C)?
- Based on the above, which employees had that type of leave?

Examples of queries I need to answer based on the summarised data:
- How many people were sick in September?
- How long was the average person sick in September?
- How many days were taken as holiday in September?
- Who was on mat leave in September?


I really hope I have explained clearly, thank you in advance.

[alansidman]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread