duplicate effort
 

I used concatenate function for the first row. Now the same function has to
be applied to the 1500 rows below it. Is there a way in which i dont have to
do it manually 1500 times?

duplicate effort
 

Assuming you didn't use absolute references, one way:

Copy the first cell. Select cells in the next 1499 rows. Paste.

In article ,
hi wrote:

I used concatenate function for the first row. Now the same function has to
be applied to the 1500 rows below it. Is there a way in which i dont have to
do it manually 1500 times?