Discussion Board for collaboration on QlikView Scripting.
I have seen it via Pivot table.
The below script seems to give your required result not sure what issue you are facing
LOAD Distinct ID,
MaxString([4 Week Flag]) as [4 Week Flag],
MaxString([8 Week Flag]) as [8 Week Flag],
MaxString([12 Week Flag]) as [12 Week Flag]
(ooxml, embedded labels, header is 1 lines, table is Sheet1)
Group by ID,Name;