Keyword Merging formula/ Macro in Excel or Googledocs
- or -
Post a project like this3105
$
- Posted:
- Proposals: 4
- Remote
- #920211
- Awarded
Description
Experience Level: Entry
General information for the business: Ability to concatenate on a massive scale
Industry: Technology
Description of excel work: I can comfortably us the concatenate function in order to concatenate cells together in Excel.
However, what I wish to do is combine EVERY cell to EVERY other cell within my 4 columns (so this is on a massive scale).
For instance, I don't simply want to concatenate A1, with B1, and C1 (that's easy).
Instead, I want to concatenate:
A1, B1, C2
A1, B2, C2,
A1, B3, C2
A1, B1, C1,
A1, B1, C2
A1, B1, C3
A1, B3, C1
A1, B3, C2
A1, B3, C3
In the 3-4 columns of data that I have in Excel, I wish to explode out and gather every single combination available (however it will always follow A, B, C, D.
I'm currently using http://mergewords.com but this crashes as soon as I get to 800,000 variates.
I'd like to engineer this approach in Excel or Googledrive, so that I can generate all of the combinations within Excel.
I hope to populate the four columns of data, and then click 'generate'. This will then calculate all of the variants.
Extra notes:
Industry: Technology
Description of excel work: I can comfortably us the concatenate function in order to concatenate cells together in Excel.
However, what I wish to do is combine EVERY cell to EVERY other cell within my 4 columns (so this is on a massive scale).
For instance, I don't simply want to concatenate A1, with B1, and C1 (that's easy).
Instead, I want to concatenate:
A1, B1, C2
A1, B2, C2,
A1, B3, C2
A1, B1, C1,
A1, B1, C2
A1, B1, C3
A1, B3, C1
A1, B3, C2
A1, B3, C3
In the 3-4 columns of data that I have in Excel, I wish to explode out and gather every single combination available (however it will always follow A, B, C, D.
I'm currently using http://mergewords.com but this crashes as soon as I get to 800,000 variates.
I'd like to engineer this approach in Excel or Googledrive, so that I can generate all of the combinations within Excel.
I hope to populate the four columns of data, and then click 'generate'. This will then calculate all of the variants.
Extra notes:
John E.
99% (71)Projects Completed
51
Freelancers worked with
58
Projects awarded
52%
Last project
16 Apr 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies