Forum Discussion
Combination formula help
Hi, I want to create a list of data which combines Data 1 with Data: A,B,C,D.. up until Z with a space in between the two words. Data 1 column has 1,000 rows, Data A,B,C,D-Z has up-to 300 rows ea...
As this type of solution requires VBA or PowerQuery, I would suggest you to use Power Query.
https://www.myspreadsheetlab.com/all-combinations-using-power-query/ solution
- I see thank you very much will give that a try!
