Sorry, i misunderstood that you want 1 sheet per project. 
Find the updated code
Option Explicit
Sub group_projects()
Dim i As Long, lrow As Long
Application.ScreenUpdating = False
Worksheets.Add(after:=Worksheets(1)).Name = "Output"
Worksheets("ProjectResourceReport").Cells.Copy Worksheets("Output").Range("A1")
With Worksheets("Output")
lrow = .Range("A" & .Rows.Count).End(xlUp).Row
.Sort.SortFields.Clear
.Sort.SortFields.Add Key:=Range("A:A") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With .Sort
.SetRange Range("A:B")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
For i = lrow To 2 Step -1
If .Range("A" & i).Value = .Range("A" & i - 1).Value Then
.Range("B" & i - 1).Value = .Range("B" & i - 1).Value & ", " & .Range("B" & i).Value
.Rows(i).Delete
End If
Next i
End With
MsgBox "Done"
Application.ScreenUpdating = True
End Sub
Bookmarks