How to create a Macro which forms new list combining elements of ColA with ColB

[LisaDavis]

I want to combine approx 100 items in column A with around 200 items in column B without having to do it by manually copying and pasting.

Below is a simplified version of what I am trying to do. Can I do this with a Macro?


[TABLE="class: grid, width: 75"]
<TBODY>[TR]
[TD]A1
[/TD]
[TD]B1
[/TD]
[/TR]
[TR]
[TD]A2
[/TD]
[TD]B2
[/TD]
[/TR]
[TR]
[TD]A3
[/TD]
[TD]B3
[/TD]
[/TR]
</TBODY>[/TABLE]

[TABLE="class: grid, width: 75"]
<TBODY>[TR]
[TD]A1
[/TD]
[TD]B1
[/TD]
[/TR]
[TR]
[TD]A1
[/TD]
[TD]B2
[/TD]
[/TR]
[TR]
[TD]A1
[/TD]
[TD]B3
[/TD]
[/TR]
[TR]
[TD]A2
[/TD]
[TD]B1
[/TD]
[/TR]
[TR]
[TD]A2
[/TD]
[TD]B2
[/TD]
[/TR]
[TR]
[TD]A2
[/TD]
[TD]B3
[/TD]
[/TR]
[TR]
[TD]A3
[/TD]
[TD]B1
[/TD]
[/TR]
[TR]
[TD]A3
[/TD]
[TD]B2
[/TD]
[/TR]
[TR]
[TD]A3
[/TD]
[TD]B3
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[mumps]

Hi hippiehacker. Thanks so much for your corrections. I've still a lot to learn!!!!

 

[LisaDavis]

Wow, that is incredibly fast and works perfect! It is even formatted nicely. Thank you and I look forward to checking out your learning resources.

Lisa

 

[hiker95]

LisaDavis,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.