vertical transposition macro

look at your never ceasing to amaze! it's working except it's not auto filling column I after the transposition, but it's doing it for F and G. I was trying to find that part in the code to tell it myself but i'm not seeing it. Sorry to be so daft.

also, i just ran it, and i think my example wasn't clear, it was for one style as a test, but in reality, the sheet i'll be working with will have hundreds of styles so the macro will need to read the whole worksheet. i'm attached a more flushed out example for your ref. you'll notice the columns are a little different, i revised the code to work with this report... which will be the report format used from now on.

Sub TransposeWIP()
Dim Sizes As Range, Itms As Range
Dim SzRws As Long, Rw As Long

'Setup
Application.ScreenUpdating = False
Application.DisplayAlerts = False

'clear output sheet if it exists
If Evaluate("ISREF(Results!A1)") Then Sheets("Results").Delete

'duplicate activesheet to create new output sheet
ActiveSheet.Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = "Results"

'insert new columns and clear WIP totals
Range("R:S").Insert xlShiftToRight
On Error Resume Next
Range("P:P").SpecialCells(xlConstants, xlNumbers).ClearContents
On Error GoTo 0

'Sizes to copy/transpose
Set Sizes = Range("T2:AE2")
SzRws = 12

'Rows to process
Set Itms = Range("L:L").SpecialCells(xlConstants, xlNumbers)

'Loop each row from the bottom up inserting values needed
For Rw = Itms.Rows.Count + 2 To 3 Step -1
    Range("A" & Rw).Offset(1).Resize(SzRws - 1).EntireRow.Insert xlShiftDown
    Range("R" & Rw).Resize(SzRws).Value = _
        Application.WorksheetFunction.Transpose(Sizes)
    Range("S" & Rw).Resize(SzRws).Value = _
        Application.WorksheetFunction.Transpose(Range("T" & Rw, "AE" & Rw))
    Range("B" & Rw, "M" & Rw).Resize(SzRws).Value = _
        Range("B" & Rw, "M" & Rw).Value
    Range("G" & Rw, "K" & Rw).Resize(SzRws).Value = _
        Range("G" & Rw, "K" & Rw).Value
Next Rw

'Cleanup
Application.ScreenUpdating = True
End Sub

figured this part out: look at your never ceasing to amaze! it's working except it's not auto filling column I after the transposition, but it's doing it for F and G. I was trying to find that part in the code to tell it myself but i'm not seeing it. Sorry to be so daft.

So, i just need the code to loop through the whole worksheet.

never mind, solved, it stops when it sees blanks, i get it now, thanks so much for your help!