Calculate non-empty rows for concatenation

Hello Internoob2,

Please check out the macro, in the attached sheet. You have to go to the sheet named "Multiple paste Values", and make sure u do not delete this sheet, as the macro is based on this sheet. You also do not delete or modify the 1st row in the sheet, the reason being the same.

U need to enter the data in column A, and the click the "Run Macro"button.

Enjoy......!!!

Please provide your valuable feedback.

Regards,
Saurav.