Converting Table Simply
There is an Excel file that teaches how to perform the Converting Table Simply operation.
Excel Professional Converting Table Simply
This workbook demonstrates converting table simply using VBA macros on a 1-row data layout.
Hope it is useful.