I am not sure if I am asking the right question, but I will try.
I am creating a pivot table with data similar to what is shown below:
When I create the pivot table, I structure it so the "ID" is in the Rows, "System" in Columns, and "Amount" in Values. I set up my pivot table in tabular format with no subtotals or grand totals.
Everything looks great so far, but I would like to include the employee's name. The issue is, I only want the name to show once, or else it looks like this:
Is there a way I can show only one name per "ID" and keep everything in one row versus two? The vendor's employee name is always in a different order than the payroll name, and it sometimes includes an initial in between the first and last name.
I would like it to look like this:
I am creating a pivot table with data similar to what is shown below:
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | System | ID | Name | Amount | ||
2 | Payroll | 5067 | John Smith III | 25 | ||
3 | Vendor | 5067 | Smith John | 25 | ||
4 | Payroll | 8855 | Debbie Brown | 30 | ||
5 | Vendor | 8855 | Brown R Debbie | 30 | ||
6 | Payroll | 3465 | Ned Flanders | 45 | ||
7 | Vendor | 3465 | Flanders Ned | 45 | ||
Sheet1 |
When I create the pivot table, I structure it so the "ID" is in the Rows, "System" in Columns, and "Amount" in Values. I set up my pivot table in tabular format with no subtotals or grand totals.
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
3 | Sum of Amount | System | |||
4 | ID | Payroll | Vendor | ||
5 | 3465 | 45 | 45 | ||
6 | 5067 | 25 | 25 | ||
7 | 8855 | 30 | 30 | ||
Sheet5 |
Everything looks great so far, but I would like to include the employee's name. The issue is, I only want the name to show once, or else it looks like this:
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
3 | Sum of Amount | System | ||||
4 | ID | Name | Payroll | Vendor | ||
5 | 3465 | Flanders Ned | 45 | |||
6 | Ned Flanders | 45 | ||||
7 | 5067 | John Smith III | 25 | |||
8 | Smith John | 25 | ||||
9 | 8855 | Brown R Debbie | 30 | |||
10 | Debbie Brown | 30 | ||||
Sheet5 |
Is there a way I can show only one name per "ID" and keep everything in one row versus two? The vendor's employee name is always in a different order than the payroll name, and it sometimes includes an initial in between the first and last name.
I would like it to look like this:
Book1 | ||||||
---|---|---|---|---|---|---|
H | I | J | K | |||
3 | Sum of Amount | System | ||||
4 | Name | ID | Payroll | Vendor | ||
5 | Ned Flanders | 3465 | 45 | 45 | ||
6 | John Smith III | 5067 | 25 | 25 | ||
7 | Debbie Brown | 8855 | 30 | 30 | ||
Sheet1 |