💻 Software
How can I create a "Cross-Join" in excel?
Fresh5 days ago
Mar 15, 202632207 viewsConfidence Score0%
0%
Problem
I have 2 sheets in excel, each with 10 rows. Is there some sort of "cross-join" formula/macro in Excel that allows me to create a 3rd sheet with all rows cross-joined (100 rows in total).
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can I create a "Cross-Join" in excel?
Low Risk
If using OLEDB is not an options below function can be used to generate cross product Once above function is added to vba module, To produce cross product of and select target cells (say E1:H25) and enter formula and use ctrl + shift + enter
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix