Merge Product and Sub-Product Text; VBA or Wild INDEX Formula
See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to merge the products and sub-products into a sigle list:
1. VBA code
2. INDEX function and “number incrementor” formula elements. See the functions IF, INT, MOD and ROWS. Learn how to increment numbers such as 1, 1, 1, 1, 2, 2, 2, 2 and 1, 2, 3, 1, 2, 3.
product names and sub-product names in one column. Join text. Concatenation.