Split Words into a Pyramid in Power Query Using List.Transform

In this Power Query tutorial, we solve a fun text transformation problem: creating a word pyramid. Each word is split into growing chunks: cat → c | ca | cat excel → e | ex | exc | exce | excel power → p | po | pow | powe | power Using List.Transform, we dynamically generate the growing substrings and combine them into a structured result. In this video you will learn: • How to generate sequences in Power Query • How List.Transform works in the M language • How to manipulate text dynamically • A powerful trick for Power Query text transformations This technique is useful for learning advanced list operations and text processing in Power Query.