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