I am trying to consolidate data from two data sources.  Some data is numeric,
some is text.

I have tried excel pivot table, multiple consolidation ranges but can't get
the text to appear - it tries to count or sum and doesn't show the text.

Any assistance would be greatly appreciated!  Thank you.  Todd.

Sample data:

ID       name     dollar    unit
123    todd      $45       3
234    Diane     $874     32
345    Ben      $125      23