Transforming Range In Bulk

There is an Excel file that teaches how to perform the Transforming Range In Bulk operation.

Excel Template for Transforming Range in Bulk

This workbook demonstrates transforming range in bulk using VBA macros on a 12-row data layout.

Hope it is useful.