Macro for mapping

[louisjeorge75]

can soemone help me on the below

i need a macro which will map data in column A and Column B

eg

Column A

1
2
3

Column B

a
b
c

i need

1A
1B
1C
2A
2B
2C
and like wise

 

[louisjeorge75]

hi i have some data in column A and col B to z

i need a macro to mapp data in col A +col B past it in a separate sheet in ColA it is similar to concatenation like wise

below is how i need the data to appear in a separate sheet

Sheet 2 Col A Sheet 2 col b

col A1 Col B1
Col A1 Col C1

once the above is colmpleted then it should move A2 and so on

hi