Forum Discussion
Need assistance in having contents of one column encompass all contents of another
Hello, I am looking to build out functionality to have each cell in "Alpha" connect to all cells in "Beta", just like the example below. This needs to be flexible enough to adjust for varying amo...
Domcach If you are willing to dive into a solution with Power Query, the attached workbook may contain just what you need, although it repeats all entries in Alpha after joining them with all entries in Beta.
Add new items at the bottom of each of the blue tables. On the Data ribbon press Refresh All and the green table will update almost instantly.
Thank you! I will work through it and see how it goes