Dear all, attaching the excel file with my data, I have 3 tabs here, Walkin is my daily calling data with their status and all, Shorlisted is where my Final Status(Column AB) is Selected, and then joining data for all who has joined.
I want to create a PivotTable that give me the journey of a candidate -
-When he was contacted- From Walkin - If he was contacted three-time all the dates
-Date of Shortlising (Column X -from Walkin), this can also be multiple times
- Date of Final Interview (Column AA- from Walkin)
-Date of Joining - from Joining table
How can I do that with or without Pivot Table?
I want to create a PivotTable that give me the journey of a candidate -
-When he was contacted- From Walkin - If he was contacted three-time all the dates
-Date of Shortlising (Column X -from Walkin), this can also be multiple times
- Date of Final Interview (Column AA- from Walkin)
-Date of Joining - from Joining table
How can I do that with or without Pivot Table?
tgh.xlsx | |||
---|---|---|---|
A | |||
1 | Record ID | ||
Walkin |
tgh.xlsx | |||
---|---|---|---|
A | |||
1 | Record ID | ||
Shortlisted |
tgh.xlsx | |||
---|---|---|---|
A | |||
1 | Record ID | ||
Joined |