I have data like below, ‘function’, ‘item’ and ‘updated part’ can have many different values, while ‘area’ would only have ‘app’ or ‘sp’ value.

Data,
| Function | Item | Area | Updated Part
| ——– | ——– |——– | ——– |
| function a | item 1 | app| app1
| function a | item 2 | sp | sp1
| function b | item 3 | app| app2
| function b | item 4 | sp | sp2

I would like to transform / summarize it into below,

Is it possible to do it through Pivot table?

I tried but the ‘Values’ area will always do count / sum function and could not display original text.