Easy Calculation: PP How to?

[JB3NOCO]

I am a intermediate user of Excel and am in the process of learning more. I have a spreadsheet of sales data. Our sales is very easy. If the sales person works alone the get 100% of the deal, or 1 count. If two people work on a sales deal together they share the deal 50/50, or .5. I have two columns of sales people.

[TABLE="width: 161"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]SALES PERSON 1[/TD]
[TD]SALES PERSON 2[/TD]
[/TR]
[TR]
[TD]GARRETT[/TD]
[TD]BRANDON[/TD]
[/TR]
[TR]
[TD]AMY[/TD]
[TD]RAY[/TD]
[/TR]
[TR]
[TD]RADLICK[/TD]
[TD]AMANDA[/TD]
[/TR]
[TR]
[TD]CHANCE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RAY[/TD]
[TD]RYAN[/TD]
[/TR]
[TR]
[TD]SLAYMAKER[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RICHARD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TELL[/TD]
[TD]RADLICK[/TD]
[/TR]
[TR]
[TD]JAMIE[/TD]
[TD]MAX[/TD]
[/TR]
[TR]
[TD]SLAYMAKER[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HARLIE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHANCE[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In this example:
Garrett - .5
Amy - .5
Radlick - .5+.5=1
Chance - 2
Ray - 1
Slaymaker - 2
Richard - 1

I am working with Pivot Tables ( if another way is easier, im all ears), how do i count the setup the PT to count the number of deals per Sales Person correctly?

 

[Matt Allington]

I would use Power Query to load the data into a different 2 column table.

Sales Person. %

each row would be 1 name followed by either 50% or 100% depending if the name came from a row that had 1 Name or 2.

In Power Query, first add a new custom column with an if statement. Pseudo code: If sales person 2 is blank, then 100% else 50%
then append sales Person 2 below sales person 1 keeping the percentage column for both.

I hope that makes sense.