Forum Discussion
booj
9 years agoFrequent Visitor
Merge multiple tables into one (iterate through combined values)
I've been banging my head against google and the search feature to figure out if there's a solution to this and I'm just using the wrong/inaccurate keywords. Any help pointing me in the right directi...
- 9 years ago
In query window in table 1 add column with formula = table 2. You will get all rows from table 2 for each row in table 1.
inetguru
Advocate I
9 years agoIn query window in table 1 add column with formula = table 2. You will get all rows from table 2 for each row in table 1.
booj
9 years agoFrequent Visitor
Beautiful! Worked like a charm.
I've got a couple issues with paring down to unique values (my list of Project identifiers is not unique as intended), but I figure I'll do my research on that before I tax the goodwill of helpful people such as you.
- inetguru9 years ago
Advocate I
Contact me if necessary