isaacr25
asked on
Help to break down spreadsheet
Hello everyone,
I have a large spreadsheet which needs to be broken down into smaller pieces of data. Please see attached for a sample of the spreadsheet, with some fake data.
I need the spreadsheet broken into lists of people (EMP_ID, LastName, FirstName, MI), grouped by Mgr Level 1. Then I need another grouping by Mgr Level 2, and so on, for each level of Mgr.
For example, there is a Mgr Level 1 called Fiction Jones. The desired outcome would be a list of people who report to Fiction Jones, which should be:
1 Smith Will A
4 Sarandon Susan A
5 Washington Denzel B
12 Zimmern Andrew C
13 Fieri Guy A
14 Mayer John B
19 Berry Halle A
Another example: There's a Mgr Level 2 called Jon Snow. The output for this manager should have his people listed as follows:
1 Smith Will A
8 Fallon Jimmy B
9 Conan Conan C
11 Bourdain Anthony B
13 Fieri Guy A
The specific output format doesn't matter (data in one worksheet, sorted, or data in different worksheets etc).
Thanks in advance for your help.
exp-exch-sample.xlsx
I have a large spreadsheet which needs to be broken down into smaller pieces of data. Please see attached for a sample of the spreadsheet, with some fake data.
I need the spreadsheet broken into lists of people (EMP_ID, LastName, FirstName, MI), grouped by Mgr Level 1. Then I need another grouping by Mgr Level 2, and so on, for each level of Mgr.
For example, there is a Mgr Level 1 called Fiction Jones. The desired outcome would be a list of people who report to Fiction Jones, which should be:
1 Smith Will A
4 Sarandon Susan A
5 Washington Denzel B
12 Zimmern Andrew C
13 Fieri Guy A
14 Mayer John B
19 Berry Halle A
Another example: There's a Mgr Level 2 called Jon Snow. The output for this manager should have his people listed as follows:
1 Smith Will A
8 Fallon Jimmy B
9 Conan Conan C
11 Bourdain Anthony B
13 Fieri Guy A
The specific output format doesn't matter (data in one worksheet, sorted, or data in different worksheets etc).
Thanks in advance for your help.
exp-exch-sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I just tried doing the Pivot Table on my real data, then changing the Report Layout to Tabular. I didn't quite get what you got. See my screenshot. What am I missing?
screenshot.png