Hello,
I would like to use the table in columns a, b, c to generate a pivot table like that in column j and y.
I know that a DAX formula is needed to be able to display text in pivot tables, but I'm a beginner and so far I have not found the right formula. A little help if you can?
Note: I use Excel 2013, not PRO version. But I installed the powerquery addin. Unfortunately, I can not use powerpivot.
Bookmarks