Transform columns with VBA
Hello
I have the following problem that I would like to solve with a VBA-macro
In column A there is a string of letters and/or numbers in every cell, e.g. A1-A6
a
za
b
hg
v
z
I would like to buikd a new column B in the following way: The content of A2 goes behind A1, the content of A3 goes behind A2 and so on
In the exemple above the column B is
abza
zabb
b2hg
hgfv
vaz
Does anybody know a VBA-macro that does this job
Kind regard
Michael E
|