Transforming Form In Order
There is an Excel file that teaches how to perform the Transforming Form In Order operation.
Excel Transforming Form in Order
This workbook demonstrates transforming form in order using VBA macros on a 12-row data layout.
Hope it is useful.