I can consolidate data, but what about text items?

[edward.montague]

Hi,

I have got the hand of consolidating data from multiple sources, but
when I consolidate non-numeric data - i.e text, it returns 0 by
default for these columns. Is there anything I can do to consolidate
and retain text items?

Thank you!

 

[sybmathics]

there is only one way to consolidate text.

in your to consolidate areas make sure to have text in only the top row
or left column.

then when you se the date >> consolidate option check the marks.

this will not consolidate values, but take only the text from the 1st
roe and left column.

for aother values in the to consolidate areas you can only use a
statistical function like max,min,average,variation,standarddeviation.

there are no statistical functions concerning text.

hth

greets,

sybolt

 

[Don Guillett]

Please, PLEASE, respond to the ORIGINAL thread.