M
midnightcallsrl
While doing a SEO job I am stuck on the following - any help is really welcome:
- I have 2 columns with several words;
- I would like to CONCATENATE all the possible combinations of the 2 columns,
- group them in columns by the content of the first column.
Example:
column A: Mr red, Mr green, Ms pruple
Column B: 1, 2
Column C: Mr red1, Mr red2
Column D: Mr Green1, Mr Green2
Column E: Ms Purple1, Ms Purple2
I can manage for the first 2 steps, but I am stuck in the last (grouping..).
Any of you is able to help, perhaps with a Macro?
Thanks,
Alex
- I have 2 columns with several words;
- I would like to CONCATENATE all the possible combinations of the 2 columns,
- group them in columns by the content of the first column.
Example:
column A: Mr red, Mr green, Ms pruple
Column B: 1, 2
Column C: Mr red1, Mr red2
Column D: Mr Green1, Mr Green2
Column E: Ms Purple1, Ms Purple2
I can manage for the first 2 steps, but I am stuck in the last (grouping..).
Any of you is able to help, perhaps with a Macro?
Thanks,
Alex