View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
[email protected] matt@weebly.com is offline
external usenet poster
 
Posts: 1
Default Using text values in Pivot Tables

On Wednesday, July 22, 2015 at 9:45:14 AM UTC-7, wrote:
In the data section of the pivot table what exactly were you wanting it to do?


I want to aggregate text values using concatenate instead of count. Or even to apply javascript-like join method on the array of aggregated text values.

Array.join('</li\n<li')


Concatenate is also what I'm looking for.