Converting Range Conditionally
There is an Excel file that teaches how to perform the Converting Range Conditionally operation.
Excel Spreadsheet for Converting Range Conditionally
This workbook demonstrates converting range conditionally using VBA macros on a 38-row data layout.
Hope it is useful.