Combination formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2934411%22%20slang%3D%22en-US%22%3ECombination%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2934411%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EHi%2C%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20want%20to%20create%20a%20list%20of%20data%20which%20combines%20Data%201%20with%20Data%3A%20A%2CB%2CC%2CD..%20up%20until%20Z%20with%20a%20space%20in%20between%20the%20two%20words.%20Data%201%20column%20has%201%2C000%20rows%2C%20Data%20A%2CB%2CC%2CD-Z%20has%20up-to%20300%20rows%20each.%20So%20I%20believe%20around%20about%20300k%20variations.%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EFor%20context%20Data%201%20is%20a%20City%2C%20Data%3A%20A%2CB%2CC%2CD-Z%20is%20a%20keyword.%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20am%20aiming%20to%20create%20a%20list%20of%20these%20variations%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EThanks!%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-11-06%20at%2013.48.14.png%22%20style%3D%22width%3A%20634px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324787iA509E400BC2A08C9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-11-06%20at%2013.48.14.png%22%20alt%3D%22Screenshot%202021-11-06%20at%2013.48.14.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2934411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2934421%22%20slang%3D%22en-US%22%3ERe%3A%20Combination%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2934421%22%20slang%3D%22en-US%22%3EI%20see%20thank%20you%20very%20much%20will%20give%20that%20a%20try!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2934415%22%20slang%3D%22en-US%22%3ERe%3A%20Combination%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2934415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1209542%22%20target%3D%22_blank%22%3E%40jimmy-j96%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20this%20type%20of%20solution%20requires%20VBA%20or%20PowerQuery%2C%20I%20would%20suggest%20you%20to%20use%20Power%20Query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.myspreadsheetlab.com%2Fall-combinations-using-power-query%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EStep-by-step%3C%2FA%3E%20solution%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 each. So I believe around about 300k variations.

 

For context Data 1 is a City, Data: A,B,C,D-Z is a keyword.

 

I am aiming to create a list of these variations

 

Can anyone help?

 

Thanks!

 

Screenshot 2021-11-06 at 13.48.14.png

2 Replies

@jimmy-j96 

As this type of solution requires VBA or PowerQuery, I would suggest you to use Power Query.

 

Step-by-step solution

I see thank you very much will give that a try!