Converting N rows to columns, including custom headers

[stepson]

Search for dynamic pivot https://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

or

Help with PIVOT

For the value in parenthese, you can add this to the table [dbo].[WellnessReport] as a column like this CREATE TABLE [dbo].[WellnessReport]( [GroupName] [varchar](50) NOT NULL, [AvgStart] [float] NULL, [AvgEnd] [float] NULL, [GroupType] [int] NULL, [NoRecords] [int] NULL ) ON [PRIMARY] INSERT INTO [dbo].WellnessReport VALUES ('0 to 3' ,10,50,0,14) INSERT INTO [dbo].WellnessReport VALUES ('4 to 6' ,17.2,52,4,23) INSERT INTO [dbo].WellnessReport VALUES ('7 to 9' ,3,65,7,5) INSERT INTO [dbo].Well…