Using the VBA to convert my comma string into rows works great- but now I need to match the break out with the value in column A. Example
Colum A has "Trees: Column B was the comma string: Dogwood,Ash,Maple,Elm,Apple.
How do I display as:
Thank you
Colum A has "Trees: Column B was the comma string: Dogwood,Ash,Maple,Elm,Apple.
How do I display as:
[font=Calibri]Current[/font] | |
[font=Calibri]Trees[/font] | [font=Calibri]Dogwood,Ash,Maple,Elm,Apple[/font] |
[font=Calibri]Need[/font] | |
[font=Calibri]Trees[/font] | [font=Calibri]Dogwood[/font] |
[font=Calibri]Trees[/font] | [font=Calibri]Ash[/font] |
[font=Calibri]Trees[/font] | [font=Calibri]Maple[/font] |
[font=Calibri]Trees[/font] | [font=Calibri]Elm[/font] |
[font=Calibri]Trees[/font] | [font=Calibri]Apple [/font] |
There are no replies made for this post yet.