Hopefully this is what you are after?

is this what you are after?

drop table testdata

Create table testdata (

Caseid [Varchar](30) NULL,

weeknum [float] NULL,

[monthName][nvarchar](255) NULL,

Response1_Num[float] NULL,

Response2_Num[float] NULL,

Response3_Num[float] NULL,

Response4_Num[float] NULL,

comments[nvarchar](max) NULL,

userlogin[varchar](max) NULL,

supervisor [varchar](max) NULL )

insert into TestData

Select 42372993071,3,'January',5,5,5,5,'We are still experiencing a problem with our job','User1','manager1'

Union ALL

select 42372993071,3,'January',5,5,5,5,'We are still experiencing a problem with our job','User1','manager1'

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User3','manager1' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User3','manager1' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User3','manager1' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALL

Select 23178234921,1,'January',3,3,1,1,'The problems cleared up on their own','User4','manager3' Union ALL

Select 12279616281,2,'January',3,2,1,1,'I just wanted more info on the issue that','User5','manager4' Union ALL

Select 45579639411,2,'January',5,5,5,5,'took some time to address the issue, but it wasnt supports fault I would guess. Thanks. Hoping to get this done faster in future','User5','manager4' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User7','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALL

Select 45680356651,1,'January',5,5,5,5,'Excellence follow up!','User8','manager6' Union ALL

Select 45680356651,1,'January',5,5,5,5,'Excellence follow up!','User8','manager6' Union ALL

Select 45680356651,1,'January',5,5,5,5,'Excellence follow up!','User8','manager6' Union ALL

Select 45680356651,1,'January',5,5,5,5,'Excellence follow up!','User8','manager6' Union ALL

Select 42380383401,1,'January',4,3,4,3,'lacks the functionality to have resolved the issue. Instead, we had to workaround the limited functionality and delete all our content and re-upload it to resolve the permissions issue.','User9','manager6' Union ALL

Select 42380383401,1,'January',4,3,4,3,'lacks the functionality to have resolved the issue. Instead, we had to workaround the limited functionality and delete all our content and re-upload it to resolve the permissions issue.','User9','manager6' Union ALL

Select 42380383401,1,'January',4,3,4,3,'lacks the functionality to have resolved the issue. Instead, we had to workaround the limited functionality and delete all our content and re-upload it to resolve the permissions issue.','User9','manager6' Union ALL

Select 42380383401,1,'January',4,3,4,3,'lacks the functionality to have resolved the issue. Instead, we had to workaround the limited functionality and delete all our content and re-upload it to resolve the permissions issue.','User9','manager6' Union ALL

Select 12380387151,4,'January',5,5,5,5,'I could browse http://xxxxx','User10','manager7' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User12','manager9' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALL

Select 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8'