Macro to Conatenate dynamic data

[shekar.ssg]

Hi Experts,

Very Good Morning !!!!

I have learnt about VBA coding with the help of you all guys thanks very much for that.

Now i'm facing a different problem i'm not sure whether i'm very weak in making the logic or the scenarion itself is difficult.

Let me explain you about my work.

We are internet providers in India i have to prepare a report on monthly basis,which will have around 40 sheets of (Hell for me data),I have attached screenshot of 1 sheet in which data would be something like in the attached pic .I need to concatenate all the rows of A & B in column C its hard to explain also.

Any help would be greatly appreciated.

Thanks,
SSG.