Show Only One Unique Value in Pivot Table?

[goob90]

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:

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

 

[igold]

I would think the simplest approach would be to use an Employee list with XLOOKUP...

Book1
	A	B	C	D	E
1	System	ID	Name	Amount
2	Payroll	5067	John Smith III	25
3	Vendor	5067	John Smith III	25
4	Payroll	8855	Debbie Brown	30
5	Vendor	8855	Debbie Brown	30
6	Payroll	3465	Ned Flanders	45
7	Vendor	3465	Ned Flanders	45
8
9
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=XLOOKUP(B2,Employees!$A$1:$A$3,Employees!$B$1:$B$3)

Book1
	A	B	C	D
1	5067	John Smith III
2	8855	Debbie Brown
3	3465	Ned Flanders
4
5
Employees