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

I should mention that there are multiple sheets with similar data that I am
trying to bring together.

"Todd1" wrote:

> 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
>
>
>