Скачать или смотреть How to Pivot Without Pivoting: Power Query Challenge 90

How to Pivot Without Pivoting: Power Query Challenge 90

Got activities assigned to multiple staff members in one messy column? In this Power Query challenge, we’ll transform that into a clean responsibility matrix where each staff member has their own column with activities neatly listed underneath. You’ll learn how to use Text.Combine, Text.Split, List.Distinct, and especially List.Transform with Table.FindText to dynamically assign work to individuals. Perfect for Excel users who want smarter solutions without messy formulas. Watch step by step and try it yourself!

Explore more tutorials:
🎥 Power Query Challenges Playlist:
   • Power Query: Challenges  
🎥 Dynamic Array Formulas Playlist:
   • Modern Excel Challenges  

#PowerQuery #Excel #HowToLearnExcel

Links:
Challenge Author: Crispo Mwangi
LinkedIn:   / crispo-mwangi-6ab49453  
Youtube:    / @crispexcel  
Challenge Post:   / crispo-mwangi-6ab49453_excelchallenge-exce...  
Solution: https://lnkd.in/dpTi2igJ