For example we have two columns: col 1-> test, col 2 → me. When trying to merge these two columns, i get a result ‘test’ instead of ‘testme’.
It’s normal behavior shown by Excel as well as Google Sheets. Probably, we will add the same warning message about the data loss.
Yes i checked in google sheet also. There also if we merge two cells the left most value only is preserved. Cleared my doubt. Thanks for your support.