I have a table that row can be added depend on the needs. I would like to combine the rows into 1 cell.

A1 KY012345

A2 KY023456

A3 KY034567

A4 …

A5 …

I am using =CONCATENATE(A1:A3)

The result should be KY012345, KY023456, KY034567, …, … depends on the rows.

In this case, the number of rows cannot be determined. Hence, cannot use fix cell range.

Would you able to help with the formula to get A3 change according to the row added?

Thank you in advance.