Merge multiple rows with comma separated value in SQL Server

Question

I have a list of diseases and balanceshow can i use sql server to display thisNameBalanceDescriptionmusoke20000Malaratyphoidmusoke50000MalaratyphoidCovid 19thanks

dharmendr · Accepted Answer

Use STUFF function to merge the column from multiple rows.

Refer:

Merge (Combine) multiple rows value with comma separated in single row using STUFF function in SQL Server
Merge multiple rows based on id and display in one row using SQL Server

Name	Balance	Description
musoke	20000	Malara,typhoid
musoke	50000	Malara,typhoid,Covid 19