Crosstab With Text as Values

[Meanmyrlin]

I need to pivot a table in which the values are text (i.e. they cannot be aggregated in any way). Is there any way of accomplishing this? The crosstab in Access and the pivot table in Excel both require your value to be aggregated in some way. Any suggestions would be greatly appreciated.

 

[Vassago]

Maybe I'm not understanding what you are trying to do. Obviously, I assume you have a field you want to become a column correct? Maybe if you explain a little more about the table structure and provide an example of what you expect as the outcome, we can help a little more.

 

[CraigDolphin]

I think your grouping options for text are limited to First or Last. After all, there's no way to average or sum a word, now is there?

The only alternative I can think of, is to write a function that takes multiple text values, combines them into one delimited string, and then use that function to provide the values for your crosstab.

Hope it helps.