When I insert data in column A and Column B, It should be automatically merged and added in column C. A   |   B    |   C  ===================ABC     CDE     ABCCDE
How to output data from Column A and Column B to Column C automatically in Google Sheet
google spreadsheets
Just put a concatenation formula into every row in column C.This is the formula to use if your values are text:  =A2&B2I'm assuming that if they were numbers, you would not just want to glue them together.   But you can extend the concatenation, like this:=A2&-&B2Here's a worked example, showing these formulas in use:   https://docs.google.com/spreadsheets/d/1NhYydERaeuKwF_myMLEjAhq8cAKGl1nAeIDJmVNVERc/edit?usp=sharing