Transforming Window Simply
There is an Excel file that teaches how to perform the Transforming Window Simply operation.
Excel Professional Transforming Window Simply
This workbook demonstrates transforming window simply using VBA macros on a 7-row data layout.
Hope it is useful.