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