should have option to concatenate table columns into one colum like in sql c= (A+B) for string and number
many times we need to add two columns value into one let's say
If I understand your request correctly, then this is already possible.
I already do this in several of my tables.Simply create a formula field and concatenate as follows:
I also use this to create unique IDs.