Forum

Thanks, that worked perfectly!!

Hi Mynda, I've attached an example. Source data table on left, pivot showing required output on right. The Group By works for average but not...

Thanks, that's perfect, I knew it would be something straight forward!