how to get multiple rows into single row in sql server

See more:

SQL

Hello,

I have a delima, and i am not really sure if this possible. But i have a table like lets say

age | type | name | dose
1 medicine x 1ml
2 vaccine y 2ml
3 water z 3ml
1 vaccine a 4ml
2 medicine e 5ml

i want to be able to return this as one row with the data from data1 in one column separated by commas.

so the result would be

1 Column
age type name dose
1 medi,vaccine x,a 1ml,4ml

how to use for xmlpath()
can anyone help me with this.

Thank you,