Pivot Table show missing value

[tan_chungkam]

Hi All,

Is there anyway to show the Fruit on 01/01/2018 and 02/01/2018?

As John has different fruit on same date, hence the pivot table won't show the value.

I would like to see 'Apple & Banana' on 01/01/2018 and 'Banana & Orange' on 02/01/2018.

Is there anyway to do it?

Please find attached my qvf and excel files.

and also my screenshot for your references.my desire outcome

[sunny_talwar · Accepted solution]

Use this expression

Concat(DISTINCT Fruit, '/')