Pivot table but with Text value

Question

Hello All,&nbsp;&nbsp;I'm trying to create the a table, similar to what pivot table was doing, but return with "text value" instead of "count value".&nbsp;&nbsp;I did some search and seems like Power Query might be able to provide the exact outcome i wanted, but, unfortunately, Power Query is not working for my working Mac for some reason. Wondering if there's any possible solution/formula i can use to create the grid. thank you!&nbsp;Example as below, first chart is the raw data using.&nbsp;the 2nd chart is what pivot is able to presentthe 3rd chart&nbsp; is what i'm expecting to see.&nbsp;

riny_van_eekelen · Answer

ytw11&nbsp;The&nbsp; query in the attached should work for you. Runs fine on my Mac.&nbsp;

ytw11 · Answer

Riny_van_Eekelen&nbsp;it works perfectly! thank you so much for the query file 🙂

Forum Discussion

Pivot table but with Text value

Share

Resources