Pivot table - values field insert text

Hi Jacks,

It looks like your Data IS what you want to arrive at. Pivot Tables will only show numbers in the Values Field. You can't get where you want with Pivots (if you put stuff in the values field).

Microsoft Access can do what you might want and using Power Query with a Non-Aggregate might also do what you want.

After doing more research, it looks like someone has a trick or two to do some of what you want, using formats!! I have no idea how they got this but see:

https://www.pivot-table.com/2009/10/...e-values-area/