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