Consolidation - including text consolidation

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

working with multiple consolidation ranges. 1
Remove lines from text file prior to importing in Excel 3
Consolidate tables/ranges with text from multiple worksheets 1
Problem importing a txt file 3
Are CRT monitor registers standard? 3
Creating ACH-style text files from Datasets in C# 2
http://netscan.research.microsoft.com/Static/reportcard.asp?timespan=y&searchdate=6/13/2004&searchfo 2
Repeated failures trying to burn audio CD -- help needed 2

Top