futureproof1
New Member
- Joined
- Aug 21, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Hi all. I am working with a spreadsheet with approximately 4500 rows of employee data, with each row representing a unique employee. Within the spreadsheet are various columns showing the following: a) job title; b) tenure in current role; c) region currently located; d) previous employer; e) previous title; f) tenure in previous role. Columns d through f repeat five times, i.e. you could see up to five previous roles, job titles, and dates of employment for each employee.
I have created a pivot table to analyze this data. My goal is to be able to see a list, by previous employer, of each of the employees at my/our current company. For example, a list of all employees who previously worked at Gizmo Corp, whether it was their immediately previous role to their current one, or whether it was three jobs ago. My challenge is it seems I need to do this "role by role," i.e. looking at the list of prior experiences one by one, and then manually amalgamating each of these disparate lists together. This is proving to be time consuming, as you might imagine. I currently have each prior role as a filter. Is there a way to combine these filters into one "mega filter" to see ALL experience over their past 5 jobs at a particular employer such as Gizmo Corp? And if so, how can I do this so I can still see unique job titles, dates of employment, etc for each INDIVIDUAL role (i.e. in case an employee worked a couple different jobs at Gizmo Corp over two different time periods)?
Happy to provide additional info if it helps. Any help here would be much appreciated!
Thanks
I have created a pivot table to analyze this data. My goal is to be able to see a list, by previous employer, of each of the employees at my/our current company. For example, a list of all employees who previously worked at Gizmo Corp, whether it was their immediately previous role to their current one, or whether it was three jobs ago. My challenge is it seems I need to do this "role by role," i.e. looking at the list of prior experiences one by one, and then manually amalgamating each of these disparate lists together. This is proving to be time consuming, as you might imagine. I currently have each prior role as a filter. Is there a way to combine these filters into one "mega filter" to see ALL experience over their past 5 jobs at a particular employer such as Gizmo Corp? And if so, how can I do this so I can still see unique job titles, dates of employment, etc for each INDIVIDUAL role (i.e. in case an employee worked a couple different jobs at Gizmo Corp over two different time periods)?
Happy to provide additional info if it helps. Any help here would be much appreciated!
Thanks