Forum Discussion
Creating table from 2 tables (20 000 rows)
Hello I'm looking for help with a problem I'm working on. I have 2 tables, Table 1 has 200 unique values (in rows) Table 2 has 100 unique values (in rows) I need to create Table 3 that will c...
An alternative could be Power Query. In the attached file you can change the entries in the blue dynamic tables. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table in another worksheet as well.