Pivot Table driving me Crazy

[Mehmood]

I have 2 Table as in picture attached.
Relationship with employee ID and Employee ID in both table
When I put employee Name in Rows
Safety Courses in column
And want to have Expiry Date of that course in Value section. But its is showing count of that course in Value instead of showing of Expiry..

H2S appearing 3 time in Safety Course's Column it is showing 3 in pivot table.

But I want to have expiry Date corresponding to Employee Name & Safety Course

 

[alansidman]

Will you post your sample data as XL2BB so that we don;t have to recreate your information to provide you with a solution.

 

[Mehmood]

First Exercise.xlsx
	A	B	C	D	E	F	G
1	EmployeeID	Employee Name	Nationality	Dept.	Grade	Category	Zip
2	1	Naveed Ul-Hassan	Pak	Cord	14	DS	75350
3	2	Mahmoud Awad Ishak	Egypt	Cord	14	DS
4	3	Ajit Nair	India	Cord	13	DS
5	4	Lyes Benarab	Algeria	SD	13	DS
6	5	Abdul Shukkoor	india	TD		DS
7	6	Praveen Tharakan	india	A.Mec		DS
Employee

Employee ID	Safety Course	Taken	Expiry
1	H2S	4-Nov-20	3-Nov-22
2	Fire Fighting	17-Jun-21	16-Jun-23
3	Huet	2-Sep-21	1-Sep-23
4	Basic Rigging	23-Dec-20	22-Dec-22
5	Fire Fighting	24-Nov-20	23-Nov-22
6	SCBA	24-Aug-21	23-Aug-23

 

[alansidman]

If the following is what you are expecting for results, since you did not show us any, then you can use Power Query and do a join of the two tables using the EE ID as a common field.

Book1
	A	B	C	D	E	F	G	H	I
10	EmployeeID	Employee Name	Nationality	Dept.	Grade	Category	Zip	Table2.Safety Course	Table2.Expiry
11	1	Naveed Ul-Hassan	Pak	Cord	14	DS	75350	H2S	11/3/2022
12	2	Mahmoud Awad Ishak	Egypt	Cord	14	DS		Fire Fighting	6/16/2023
13	3	Ajit Nair	India	Cord	13	DS		Huet	9/1/2023
14	4	Lyes Benarab	Algeria	SD	13	DS		Basic Rigging	12/22/2022
15	5	Abdul Shukkoor	india	TD		DS		Fire Fighting	11/23/2022
16	6	Praveen Tharakan	india	A.Mec		DS		SCBA	8/23/2023
Sheet1

 

[Mehmood]

Actually I want to have result as blew. Date Could be Expiry Date or Taken Date.

Employee ID	H2S	Fire Fighting	Huet	Basic Rigging	Fire Fighting	SCBA
Abdul Shukkoor	4-Nov-20	3-Nov-22	3-Nov-22	3-Nov-22	3-Nov-22	3-Nov-22
Ahmed Bakr	17-Jun-21	16-Jun-23	16-Jun-23	16-Jun-23	16-Jun-23	16-Jun-23
Ahmed Hamdi	2-Sep-21	1-Sep-23	1-Sep-23	1-Sep-23	1-Sep-23	1-Sep-23
Ahmed Mostafa	23-Dec-20	22-Dec-22	22-Dec-22	22-Dec-22	22-Dec-22	22-Dec-22
Ajit Nair	24-Nov-20	23-Nov-22	23-Nov-22	23-Nov-22	23-Nov-22	23-Nov-22

 

[Mehmood]

Actually I want to have result as blew. Date Could be Expiry Date or Taken Date. I could also be filtered like want to check whose course expiring on this month.

Employee ID	H2S	Fire Fighting	Huet	Basic Rigging	Fire Fighting	SCBA
Abdul Shukkoor	4-Nov-20	3-Nov-22	3-Nov-22	3-Nov-22	3-Nov-22	3-Nov-22
Ahmed Bakr	17-Jun-21	16-Jun-23	16-Jun-23	16-Jun-23	16-Jun-23	16-Jun-23
Ahmed Hamdi	2-Sep-21	1-Sep-23	1-Sep-23	1-Sep-23	1-Sep-23	1-Sep-23
Ahmed Mostafa	23-Dec-20	22-Dec-22	22-Dec-22	22-Dec-22	22-Dec-22	22-Dec-22
Ajit Nair	24-Nov-20	23-Nov-22	23-Nov-22	23-Nov-22	23-Nov-22	23-Nov-22

 

[alansidman]

Your response makes no sense to me. Why are you showing Blue and non colored if only you want Blue.