Formatting Data Advanced
There is an Excel file that teaches how to perform the Formatting Data Advanced operation.
Excel Powered Formatting Data Advanced
This workbook demonstrates formatting data advanced using VBA macros on a 87-row data layout.
Hope it is useful.