How to merge cells in excel without losing data | Excel made easy

Описание: First, you can merge data from different columns into a single column, using spaces, commas, or other separators to keep it clean.

Formulas used-
1. =B5&C5&”@”&D5&”.com”
2. =CONCAT(B5,C5,”@”,D5,”.com”)
3. =TEXTJOIN(,TRUE,B5,C5,”@”,D5,”.com”)

Second, you can stack columns on top of each other to create a clear and compact view of related data sets.

Formulas used-=INDEX($B$5:$E$8,1+INT((ROW(B1)-1)/COLUMNS($B$5:$E$8)),MOD(ROW(B1)-1+COLUMNS($B$5:$E$8),COLUMNS($B$5:$E$8))+1)

Chapters:

00:00 Introduction
00:34 Merge/combine data into single column
00:57 Ampersand (&) function
01:38 CONCAT function
02:38 TEXTJOIN function
03:42 Stack one column over another
03:50 INDEX function
05:10 Working of INDEX function


#excel #exceltutorial #exceltips #exceltricks #excelformula #excelformulas #index #concatenate #ampersand #textjoin #columns #merge #combine #two #single