Need Help with Transposing Data in Excel

You can accomplish this easily with vba.

Option Explicit

Sub UNPIVOT()
Dim ARY()
Dim shtNew As Worksheet, r As Long, c As Long, newR As Long, newC As Long
With Selection
    Set shtNew = Worksheets.Add
    On Error Resume Next
    Application.DisplayAlerts = False
    Sheets("Unpivot").Delete
    Application.DisplayAlerts = True
    On Error GoTo 0
    shtNew.Name = "UnPivot"

    
    For r = 1 To .Rows.Count
        newC = 0
        For c = 3 To .Columns.Count
            If r = 1 Then
                newR = 1
            Else
                newR = newR + 1
            End If
            
            shtNew.Cells(newR, 1) = .Cells(r, 1)
            shtNew.Cells(newR, 2) = .Cells(r, 2)
            shtNew.Cells(newR, 3) = .Cells(r, c)
'            MsgBox shtnew.Cells(NEWR, 1) & " " & ARY(NEWR, 2) & " " & ARY(NEWR, 3)
        Next c
        
        
        Next r
    MsgBox "done"
     Sub

Select allOpen in new window

If there were 5 user name columns and you wanted to do this without vba
1. copy whole area.
2. create a new sheet named UnPivot
3. paste the area 5 times into UnPivot
4. In the second pasted area select the cells in C and delete them with shift right.
5. In the thired pasted area select the cell in C:d and delete them
6. In the fourth area delete c:e
7. in the fifth area delete c:f
8. to finish things off, delete cells d:f

Thanks