trouble formatting output

Having trouble figuring out how to format this. DB data is: id month company title name part I'm grouping and ordering the data in my SQL query and basically only want to display the month, company, and title ONLY when they change. So for instance I may have: 2002-04-01 company1 title1 name1 part1 2002-04-01 company1 title1 name2 part2 2002-04-01 company1 title1 name3 part3 2002-04-01 company1 title1 name4 part4 2002-04-01 company1 title2 name1 part1 2002-04-01 company1 title2 name2 part2 2002-05-01 company2 title3 name1 part1 2002-05-01 company2 title3 name2 part2 2002-05-01 company2 title3 name3 part3 2002-05-01 company2 title3 name4 part4 and want to format like: 2002-04-01 company1 -title1 name1 part1 name2 part2 name3 part3 name4 part4 -title2 name1 part1 name2 part2 2002-05-01 company2 -title3 name1 part1 name2 part2 name3 part3 name4 part4 Having a hard time putting this together in my head, any help would be appreciated. -Brian