Now it’s time to combine the two tables and perform the monthly name repeats for each name.
Begin by selecting Add Column (tab) -> Custom Column.
In the Custom Column dialog box, set the new column’s name to “Month” and enter the following formula and click OK:
This will produce a list of nested tables.
To extract the contents of each nested table, click the Expand Tables button located in the header of the newly added “Month” column.
Uncheck the “Use original column name as prefix” and click OK.
We now see a list of each name repeated for as many months as are in the “Months” table.
Before we load the results back to Excel, it’s considered a “best practice” to set the proper data type for each column.
We already have the “Names” column set to Text. Let’s also set the “Months” to a Text data type.