Excel Merge !!link!! -

If you need the look of merged cells (like a centered title over five columns) without breaking your data functionality, use instead:

: Use =TEXTJOIN(" ", TRUE, A1:B1) to combine cells with a space while ignoring blanks. excel merge

If you have more than one cell with data, Excel keeps only the top-left value and deletes the rest. No warning. No undo (after save). Just gone. If you need the look of merged cells

Combines A2, B2, C2 with a comma and space, ignoring blanks. use instead: : Use =TEXTJOIN(" "

If your data is small, just copy Sheet 2 and paste it under Sheet 1. It’s low-tech, but effective.