Expanding and Shrinking Column
There is an Excel file that teaches how to perform the Expanding and Shrinking Column operation.
Excel Solution: Expanding and Shrinking Column
This workbook demonstrates expanding and shrinking column using VBA macros on a 18-row data layout.
Hope it is useful.