Merging Text with Formula
There is an Excel file that teaches how to perform the Merging Text with Formula operation.
Excel Merging Text with Formula
This workbook demonstrates merging text with formula using VBA macros on a 2-row data layout.
Hope it is useful.