Converting Data Automatically

There is an Excel file that teaches how to perform the Converting Data Automatically operation.

Excel Solution: Converting Data Automatically

This workbook demonstrates converting data automatically using VBA macros on a 12-row data layout.

Hope it is useful.