Formula to merge cells

[Pasadu]

Please is there a formula to merge cells that have the same texts without necessarily doing manual merging?

 

[herofox]

Please Upload Excel File AS Example

 

[pecoflyer]

TEXTJOIN ? CONACTENATE ? The "&" operator?

 

[Pasadu]

Please Upload Excel File AS Example

I want to know that if after using formula to generate the Gender, is there a way I could have used a formula to merge the data in the Gender column since they all refers to the same thing (Female).

Thank You

 

[Debaser]

No, you cannot merge cells with a formula.

 

[Pasadu]

Thank You Sir.

No, you cannot merge cells with a formula.