They each teach us different things about Power Query, so it’s worth working through both and understanding the differences. In this post, there are two solutions presented. Let’s dig into Power Query to see how we can solve this problem. We’ll need to get a little more involved. Sounds simple, right? There must be a single function in Excel or Power Query that will generate that… right?Įr, actually… No. The question might come in a simple form, such as: “How can we get a complete list of all General Ledger and Cost Centre combinations?”. Imagine a scenario where you have two or more lists in Excel and want to create a single table of all possible combinations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |