Hello
I am trying to write a macro that joins strings of text together whilst also transposing. I'll try provide an example of what I'm after:
So here is table 1, where we write the campaign name, the ad group name and its associated keyword(s).
A B C D
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
A B C
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks for your help!
I am trying to write a macro that joins strings of text together whilst also transposing. I'll try provide an example of what I'm after:
So here is table 1, where we write the campaign name, the ad group name and its associated keyword(s).
A B C D
Campaign Name: | Campaign 1 | Campaign 2 | Campaign 3 |
Adgroup Name: | Ad group 1 | Ad group 2 | Ad group 3 |
Keywords: | Shoes | dresses | towels |
blue shoes | blue dresses | blue towels | |
pink towels red towels | |||
What I want is a macro that will assign each keyword with its respective campaign name/ad group, per line, as shown: |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
A B C
Campaign Name | Adgroup name | Keyword |
Campaign 1 | Ad group 1 | Shoes |
Campaign 1 | Ad group 1 | blue shoes |
Campaign 2 | Ad group 2 | dresses |
Campaign 2 | Ad group 2 | blue dresses |
Campaign 3 | Ad group 3 | towels |
Campaign 3 | Ad group 3 | blue towels |
Campaign 3 | Ad group 3 | pink towels |
Campaign 3 | Ad group 3 | red towels |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks for your help!