Combine duplicate rows into single row based on column value

Have a Look Here at different approaches for grouping Data