Copy a colum where add data in every year to another column

[Shahadat65]

Greetings and good day to every one.


I have a problem as below and need help. Hope kind enough to help me.

I have following years in one column say A1,A2,...
A B
2012
2013
2014
2015
2016
2017
2018
2019
2020

In another column say C ... I have following data
C
10
20
30


I want to copy 10 next to 2012 in B1, 20 next to 2013 in B2 and 30 in B3 next to 2014 and so on.

After that if any data add in in column C it will automatically copy next to 2015 in B4,
This continuation will end up in year 2020

Can you please give me excel formula for this or excel VBA code which one is easy for me.

With warmth regards,
Shahadat Hossain

[SamT]

Formula in B1
=CONCATENATE(A1,C1)
Copy down to bottom

Also try
=CONCATENATE(A1, " - ",C1)

And try
=CONCATENATE(A1, " ",C1)