Merry Christmas and a Happy New Year.

Don't double post.  You have already asked this question here: https://www.sqlservercentral.com/Forums/2014477/Need-Help-Load-in-SSIS-2-large-excel-files-with-different-structures1-file-has-5-less-columns-that-o.

FOUR-PEAT!!!!

Any given Sunday!!

Please post the code you have written in a effort to solve your problem and what problem(s) you are encountering with your code.
Having looked at your other posts it...

Without the base data that is being converted to a JSON message, not much can be offered.

Learned this a while ago.  Good question.

You need to use a tally table.  In the code below I create one as part of the query.

declare @AppDate datetime = '2014-01-01';

with e1(n)...