Hi.
I need to create an excel sheet for about 5000 rows. The data consists of following entities:
1. Name of the person
2. Family of the person(Son/daughter, spouse, mother, father)
3. Date of joining (person only)
P.S. There wll be deletions and additions each month of employees.
How do I organize the data in order to perform charting, filtering and pivoting at a later stage?
I need to create an excel sheet for about 5000 rows. The data consists of following entities:
1. Name of the person
2. Family of the person(Son/daughter, spouse, mother, father)
3. Date of joining (person only)
P.S. There wll be deletions and additions each month of employees.
How do I organize the data in order to perform charting, filtering and pivoting at a later stage?