Merging Formula Advanced
There is an Excel file that teaches how to perform the Merging Formula Advanced operation.
Excel Solution: Merging Formula Advanced
This workbook demonstrates merging formula advanced using VBA macros on a 37-row data layout.
Hope it is useful.