Writing Columns Automatically
There is an Excel file that teaches how to perform the Writing Columns Automatically operation.
Excel Powered Writing Columns Automatically
This workbook demonstrates writing columns automatically using VBA macros on a 1-row data layout.
Hope it is useful.