How to get values same of column but seperate rows as comma seperated

Question

The left column data should be at the same row. but particular column data should be comma seperated

Answer 1

What do you mean? Are you trying to write a query? Or is it from data access code prespective?